Đã hoàn thành

Create the amortization table as indicated below

Suppose that Isabel and Chris are very responsible first-time homebuyers. They have a down payment of $120,000 which is 20% of a $600,000 home that they hope will help them avoid private mortgage insurance (PMI). PMI is insurance to cover the lender in case the buyer is not able to repay the loan. With their down payment, Isabel and Chris have committed to stick to a sales price of $600,000 or less. They are working with a loan officer who has presented them with two different options. Plan A is that they borrow $480,000 on a 30-year fixed rate loan at an interest rate of 6%. Plan B is that they pay four points (4% of the loan) to get a lower interest rate, and then they roll the point amount into the loan amount. This means that they borrow $499,200 on a 30-year fixed rate loan to get a smaller interest rate of 5.5%. Isabel and Chris feel confused, so they call their parents and ask for advice.

Note that the end balance for the last time point is most likely somewhat less than the regular payment. In this case, adjust the last payment accordingly.

1. Write a SAS program that uses a DATA step to create an amortization schedule for plans A and B. The program should create the following variables for each observation: time period (by month), beginning balance, payment amount, interest amount for that payment, principal for that payment, and the end balance.


To make matters worse, their parents say that no matter what plan they choose they should add an additional $150 to their payment every month so that they can pay off their loan earlier. This gives Isabel and Chris two more scenarios. Plan C is that they borrow $480,000 on a 30-year fixed rate loan at an interest rate of 6%, and they add an additional $150 each month to their principal. Plan D is that they pay four points (4% of the loan) to get a lower interest rate of 5.5% rolling it into the loan amount totaling $499,200, and they add an additional $150 each month to their principal.

Create an amortization schedule for the $150 pre-payment plans C and D. Make sure that for each schedule only the time periods where there is an actual balance get output to the data set. In other words, scenarios C and D will allow them to pay the loan off sooner than 30 years, so only print the applicable time points. In this way, they will know how early the loan will be paid off. Also, throughout the schedule, the payment amount variable should include the $150 extra that they will be applying toward their principal balance.

Kĩ năng: Kế toán, SAS

Xem nhiều hơn: vbnet create word table datatable, create acces table, fcmspro create mysql table, create pivot table, create mysql table form post, create custom table headers myspace, mysql create lookup table, create custom table visio shape, create timeofday table, create database table xml schema, create mysql table form data, create modern table living room 3ds max, create access table, create odbc table access, create xml table

Về Bên Thuê:
( 1 Nhận xét ) NEWARK, United States

ID dự án: #16733468

Được trao cho:


Hi! I´m a expert SAS Developer-Analyst, i work with SAS Base in a Bank enterprise. If you want tell more about your project in chat. I will be glad to help you. Thanks

$30 USD trong 3 ngày
(1 Nhận xét)

8 freelancer đang chào giá trung bình $24 cho công việc này


"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business Thêm

$50 USD trong 1 ngày
(28 Nhận xét)

Dear client, I am Jack201307. Thank you very much for posting the project “Create the amortization table as indicated below”. I am using SAS to analyze data every day, have 2 SAS certificates. Recently I successful Thêm

$35 USD trong 1 ngày
(9 Nhận xét)

I have high proficiency in SAS programming including data manipulation techniques,Excel, Excel VBA, R Programming Language, Machine learning, macros & sql and know how to use statistical techniques like regression & an Thêm

$10 USD trong 1 ngày
(2 Nhận xét)

Hello, After reviewing your needs, I am confident I can complete this work for you right away. I am working on building my profile with completed jobs, so I am bidding at the lowest point of your Project Budget. Thêm

$10 USD trong 0 ngày
(1 Nhận xét)

Hi am a CPA who passed the board and was part of the top 10. I believe that i could be of help for this job. Relevant Skills and Experience I have high grades in both financial accounting and financial mgt which cover Thêm

$10 USD trong 1 ngày
(0 Nhận xét)
$20 USD trong 2 ngày
(0 Nhận xét)

Hello, I am a SAS analyst with more than 6 years of experience working with clients across the globe. Please ping for futher details on your amortization table requirement. Regards, Yash

$30 USD trong 3 ngày
(0 Nhận xét)