Calculates the blended interest rate

Assignment Help Finance Basics

Reference no: EM1364498

Make a usable spreadsheet that can calculate the blended interest rate for 2 separate loans. Below is an example of the output data that this spreadsheet would produce for this particular scenario:

Mortgage Loan Summary
Loan one amount $250,000.00
Interest Rate 5.25%
Term 30 years
Monthly payment $1,093.75 Interest Only
Loan two amount $160,000.00
Interest Rate 7.00%
Term 30 years
Monthly payment $933.33 Interest Only
Total amount financed $410,000.00
Total monthly payment $2,027.08
Blended interest rate 5.933%

I need a simple excel tool in which one may enter the amount and interest rate for two separate loans and amounts that calculates the blended interest rate for those two "interest-Only" loan amounts.

Reference no: EM1364498

Questions Cloud

Free and competitive markets and the tabacco industry : Do you believe that a free and competitive market should determine the success of a product or service? Or do you believe that the government should have more control over the market?

How much charge is applied to each of the cylinders : How much charge is applied to each of the cylinders.

The ramifications of groupthink : Describe a situation where you experienced groupthink. Were you able to overcome groupthink in that situation? If so, how? If not, why?

Compute its current position in terms company''s key : Compute its current position in terms of two (2) of the company's key competitors and the industry as a whole

Calculates the blended interest rate : Make a usable spreadsheet that can compute the blended interest rate for two separate loans. Below is an example of the output information that this spreadsheet would produce for this particular scenario:

At what distance from the rings center is e maximum : At what distance from the ring's center is E maximum. How deep is the tank.

Signs of suspected spinal injury : You come across an unresponsive victim, who is breathing, and shows no signs of suspected spinal injury. What position should you put them in? Why is this important, and what steps would you take to get them in that position?

Purpose of engagement planning : What is the purpose of engagement planning? What critical information should the auditor consider during engagement planning? How will this information affect the scope of the audit?

Write program to ask user to enter last name of customer : Write a program that will ask the user to enter the last names of our candidates in a class officer's president election and the number of votes received each candidate.

User Account

All Pages