Make a usable spreadsheet that can compute the blended, Ask an Expert

Finance

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.

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M9284813

Have any Question?Write your Review or question?

Related Questions in Basic Finance

What methods will you use to effectively manage

What methods will you use to effectively manage expectations for a project. There are many different types of stakeholders on a project. Do their expectations differ? How can you work to ensure that the project does not ...

Assume that the expected rates of inflation over the next 5

Assume that the expected rates of inflation over the next 5 years are 4 percent, 7 percent, 10 percent, 8 percent, and 6 percent, respectively. What is the average expected inflation rate over this 5-year period? 6% 9% 8 ...

Nbspyou paid cash for 1300 worth of stock a year ago today

You paid cash for $1,300 worth of stock a year ago. Today the portfolio is worth $1,888. a. What rate of return did you earn on the investment? b. Now suppose that you bought the same stock but bought it on margin. The ...

The satellite shoppe has current sales per share of 840 the

The Satellite Shoppe has current sales per share of $8.40. The sales per share are expected to increase at an annual rate of 12%. The historical P/E ratio is 16.2 and the historical P/S ratio is 7.6. What is the expected ...

What is marketing discipline what is most peoples

What is marketing discipline? What is most people's perception of marketing discipline? Name an organization that has done a great job marketing. What did they do to make you feel this way?

Describe a bank accepted bill and explain the role of the

Describe a bank accepted bill, and explain the role of the acceptor, payee, drawer and discounter, in the context of bank accepted bills.

A firm recently paid a 044 annual dividend the dividend is

A firm recently paid a $0.44 annual dividend. The dividend is expected to increase by 10 percent in each of the next four years. In the fourth year, the stock price is expected to be $20. If the required return for this ...

A firm is considering the two mutually exclusive

A firm is considering the two mutually exclusive investments projects. Project Alpha requires an initial outlay of $600 and will return $160 per year for the next seven years; Project Beta requires an initial outlay of $ ...

Youre prepared to make monthly payments of 210 beginning at

You're prepared to make monthly payments of $210, beginning at the end of this month, into an account that pays 6.2 percent interest compounded monthly. How many payments will you have made when your account balance reac ...

Set up and solve a valuation for thew following

Set up and solve a valuation for thew following non-constant growth stock: A stock will pay a $2.00 dividend in year 1. It will grow at 2% for years 2 and 3, and then at 4% for years 4 and 5, then at 5% thereafter. The 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