Excel assignment you are going to purchase a new house, Ask an Expert

Finance

Excel Assignment

You are going to purchase a new house valued at $250,000 by making the down payment of 20% and borrowing the rest as a 30-year fixed rate mortgage of 5.25%.

Solve the problem by creating an Excel spreadsheet like the one presented in the video.

1-What will be your monthly payment to pay back the loan? What is the total interest that you will pay over the life of the loan?

2-How much total interest you would pay on this loan if you can prepay $30,000 on the first month of the second year?

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M92070941

Have any Question?Write your Review or question?

Related Questions in Basic Finance

The current risk-free rate of return is 3 and the market

The current risk-free rate of return is 3% and the market risk premium is 6%. If the beta coefficient associated with a firm's stock is 1.5, what should the stock's required rate of return be?

Consider the stock of abc inc a growth stock that will

Consider the stock of ABC Inc., a growth stock that will increase its dividend by 20 percent for the next two years and then maintain a constant 12 percent growth rate, thereafter. The stock has a required rate of return ...

A project has an initial outlay of 4623 it has a single

A project has an initial outlay of $4,623. It has a single payoff at the end of year 3 of $8,869. What is the net present value (NPV) of the project if the company's cost of capital is 12.43 percent?

Able corporation has project a with the following cash

Able Corporation has Project A with the following cash flows and a 6.8% cost of money: Numbers in parentheses are outflows. Both Year 0 and Year 3 cash flows are outflows. What is the net present value? Year Cash flow 0 ...

Suppose you want to raise 15m for a new machine you plan to

Suppose you want to raise $15m for a new machine. You plan to raise the funds by selling 20-year $1,000 bonds with a semi-annual coupon rate of 5% and 8% yield. Before putting the bonds to market, inflation drops half a ...

You purchases a house for 18133300 you made a down payment

You purchases a house for $181,333.00 . You made a down payment of 20,000 and the remainder of the purchase price was financed with a mortgage loan. The mortgage loan is a 30 year mortgage with an annual interest rate of ...

The firm has bonds that pay a 5 coupon rate mature in 10

The firm has bonds that pay a 5% coupon rate, mature in 10 years and sell for $975. The preferred stock is selling for $35 and pays a $3.00 dividend. The common stock is selling for $20, just paid a $2.25 dividend and is ...

What is the present value of a security that will pay 9000

What is the present value of a security that will pay $9,000 in 20 years if securities of equal risk pay 12% annually? Round your answer to the nearest cent

What are some key factors needed for consideration in

What are some key factors needed for consideration in choosing a business location and why is location a key finance factor for most businesses?

With its current leverage cowcow copr will have net income

With its current leverage, COWCOW copr will have net income next year of $7 million. If COWCOWs corporate tax rate is 30% and it pays 7% interest on its debt, how much debt can COWCOW issue this year and still receive th ...

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