# 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.

2.

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.

Kemahiran: Perakaunan, SAS

Tentang Majikan:
( 1 ulasan ) NEWARK, United States

ID Projek: #16733468

montanez

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 dalam 3 hari
(1 Ulasan)
1.0

## 9 pekerja bebas membida secara purata \$23 untuk pekerjaan ini

Tanmoy236

"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 Lagi

\$50 USD dalam sehari
(17 Ulasan)
4.1
Jack201307

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 Lagi

\$35 USD dalam sehari
(6 Ulasan)
3.5
olaideejiwole

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 Lagi

\$10 USD dalam sehari
(0 Ulasan)
0.0
eternalvs

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. Lagi

\$10 USD dalam 0 hari
(0 Ulasan)
0.0
akockim

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 Lagi

\$10 USD dalam sehari
(0 Ulasan)
0.0
\$20 USD dalam 2 hari
(0 Ulasan)
0.0
mohamedahmed2016

I think I can do this project efficiently and in less than one hour. it is my pleasure to award me this project.

\$10 USD dalam sehari
(0 Ulasan)
0.0
cyash61

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 dalam 3 hari
(0 Ulasan)
3.5