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?

Can you please help how do you get to those answers and

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!