Question: Question 1 25 pts Use 2 separate tabs for these 2 questions. 1. Build a loan amortization schedule using goal seek. The info of the
Question 1 25 pts Use 2 separate tabs for these 2 questions. 1. Build a loan amortization schedule using goal seek. The info of the loan: Amount of the loan: $500,000 Length of the loan: 30 years Interest rate: 4% for the first 15 years, and 5% for the rest of the 15 years. Payment: During the first 15 years, the borrower pays fixed amount of payment. Then during the second 15 years, the borrower pays another fixed amount of payment that's 3% more than that in the first 15-year period. Set up your input section, so that your model is flexible and will update automatically with any changes to the inputs
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
