Create the amortization spreadsheet and answer the, Ask an Expert

Finance

Create the amortization spreadsheet and answer the following questions for a $350,000 15-year fixed-rate, constant-payment mortgage loan that is partiallyamortizing with a balloon payment of $100,000. The contract interest rate is 4% with monthly payments. Up-front discount points on the loan are 4%, and there is a 1% prepayment penalty.

please post spreadsheet with formulas visible

a) What is the APR (annual percentage rate) on the loan – assuming that there is no early prepayment on the mortgage?

b) What is the EAR (effective annual rate) on the loan if it prepaid at the end of year 7?

c) What is the monthly mortgage payment during month 160?

d) How much cumulative interest is paid during the 14th year of the mortgage?

View complete question

Financial Management, Finance

Category:- Financial Management
Reference No.:- M92079295

Have any Question?Write your Review or question?

Related Questions in Financial Management

Assignment the art of negotiationresearch a current

Assignment : The Art of Negotiation Research a current conflict or negotiation in progress from the last 6 months like peace talks in the Middle East, a corporate merger, a labor dispute, etc. Write a six to eight (6-8) ...

Assignment - capital asset pricing model and required

Assignment - Capital asset pricing model and required returns 1. Select two stocks that have prices available for the last ten years. (You may find it more interesting if you select one stock that is relatively risky and ...

Use the internet to locate information regarding a

Use the Internet to locate information regarding a negotiation from the past 6 months that you would consider to be integrative in nature. Examine the differences between distributive and integrative negotiation. Determi ...

Question 1youre asked to assess whether your corporation

Question 1. You're asked to assess whether your corporation should invest in a long-term capital project. You calculate the payback period and NPV. Give an example of a specific recommendation you could make based on the ...

Assignment problems1 on the day harry was born his parents

Assignment Problems 1. On the day Harry was born, his parents put $1600 into an investment account that promises to pay a fixed interest rate of 5 percent per year. How much money will Harry have in this account when he ...

Uit analyzing and managing inventorydeliverable length

Unit: Analyzing and Managing Inventory Deliverable Length: 8-10 PowerPoint slides with speaker notes Library Research Assignment After the last report, the owners of Stone Horse Supply Company, John and Michael, have con ...

The investment logic for sustainabilitywatch the investment

The Investment Logic for Sustainability Watch the Investment Logic for Sustainability video. Then perform a few internet searches on terms such as the following: Sustainable funds Socially responsible investing ESG Envir ...

In the land of free trade the public does not view all

In the land of free trade, the public does not view all industries as equal. Do you believe that is ethical? Do you believe that some industries are unfairly targeted? Should it be consumers' choice to partake in product ...

Consumer behavior assignment - personality and

Consumer Behavior Assignment - Personality and Lifestyles 1. What are some products that make their appeals primarily to the id? What are some products that make their appeals to the superego? Do products make an appeal ...

Introductionlast week you determined the root causes of the

Introduction Last week, you determined the root cause(s) of the problem you are trying to resolve for your final paper. As a reminder, the decision you are working on is the one that you selected in week two. This week, ...

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 Financial Management Expert