(Answered) Assgnment construction of an amortization schedulesee excel

Finance

Assgnment: Construction of an Amortization Schedule

SEE EXCEL TEMPLATE - ATTACHED

You plan to purchase a $750,000 home using a 30-year mortgage obtained from a local commercial bank.

The mortgage rate offered is 5.25 percent and requires a 20 percent down payment.

a. What are the monthly payments on the mortgage?

b. Construct the amortization schedule for the first 10 payments. see chart on excel file.

c. If the rate offered was 7.50 percent, what would the monthly payments be?

d. If a 15-year mortgage with a 4.50 percent rate and 20 percent down payment was obtained for the purchase, what would the monthly payments be?

Attachment:- Construction-of-an-Amortization-Schedule.rar

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M92401963
Price:- $30

Verified Expert

Priced at $60 Now at $30, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Basic Finance

What are the ways that it can help comply with legal

What are the ways that IT can help comply with legal requirements and social responsibilities surrounding the sales of alcohol?

How much would you pay for a share of preferred stock that

How much would you pay for a share of preferred stock that pays a $3.25 dividend and your required return for an investment of this kind is 7%?

Question - gamma energy is an oil producing company that

Question - Gamma Energy is an oil producing company that owns an oil field from which it can deliver 10 mln barrels of oil per year for the next four years. The current oil price is USD 75 per barrel. Extraction costs ar ...

Can anyone explain this topic consolidation can hide

Can anyone explain this topic 'Consolidation can hide imminent business collapse'. If you can share your argument with real examples that will be much appreciated.

1 you currently owe 4066 to your credit card that charges

1. You currently owe $4,066 to your credit card that charges an annual interest rate of 22.00%. You make $165 of new charges every month and make a payment of $155 every month. What will your credit card balance be in th ...

You have just made your first 5200 contribution to your

You have just made your first $5,200 contribution to your retirement account. Assume you earn a return of 12 percent per year and make no additional contributions. a. What will your account be worth when you retire in 43 ...

What are the main reasons for dji competitiveness in the

What are the main reasons for DJI competitiveness in the Drone Market? What are the main differences in the customers needs and values in the customer retail and Commercial professional drone market?

Fidelity select health care portfolio is a sector mutual

Fidelity Select Health Care Portfolio is a sector mutual fund that has returned 16 % annually, on average, in the past 10 years. This is significantly higher than the S&P average of 11.24%. Is this proof that stock marke ...

How much of the opposing side should you share in a

How much of the opposing side should you share in a presentation to a multiple-perspective audience, and what techniques would you use?

Leibniz sells you an annuity that pays 1500 every month

Leibniz sells you an annuity that pays $1,500 every month from the end of September 2018 to the end of August 2022 with annual interest rate 7% compounded monthly. (round off all answers to two decimal places) (a) What i ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert