Question: Can you please help how do you get to those answers and how do you in put them in excel formula? 1. You have the
Can you please help how do you get to those answers and how do you in put them in excel formula?

1. You have the opportunity to make a $180,000 investment that will pay you a fixed amount monthly for 25 years. Each payment will consist of interest and principal repayment. Your required rate of return is 8%. What payment amount will you accept? PMT = $1,389.27 2. Calculate the mortgage payments for a $180,000 level payment mortgage loan amortized for 25 years at 8% interest if the payments are made annually. PMT = $16,862.18 3. How much of the first year's payment would be principal and how much would be interest? Int - $14,400 Prin = $2,462.18 4. If the mortgage is for 25 years with monthly amortization, what are the monthly payments? PMT - $1 389.27 Focus
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
