Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

Loan Amortization
Make a loan amortization table in excel.
House Z cost $120,000. You put down 20%. The rest is financed for 30 years @ 4.5% APR. Now, rework table with an extra $50 in payments.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M91246269
  • Price:- $20

Priced at Now at $20, Verified Solution

Have any Question?


Related Questions in Basic Finance

General mills has a 1000 par value 15-year to maturity bond

General Mills has a $1,000 par value, 15-year to maturity bond outstanding with an annual coupon rate of 8.01 percent per year, paid semiannually. Market interest rates on similar bonds are 8.15 percent. Calculate the bo ...

Assume that real risk-free rate r 100 the maturity risk

Assume that real risk-free rate (r*) = 1.00%; the maturity risk premium is found as MRP = 0.20%×(t - 1), where t = years to maturity; the default risk premium for AT&T bonds is found as DRP = 0.07%×(t - 1); the liquidity ...

Question - laine needs to save up 4000 in 4 years if she

Question - laine needs to save up $4000 in 4 years. If she can set aside $1000 today, what rate of return does she need on her account? Elaine needs to save up $4000 in 4 years. If she can set aisde $50 per month what ra ...

Suppose that a zero-coupon bond that matures in 1 year

Suppose that a zero-coupon bond that matures in 1 year costs $97 and that a zero-coupon bond that matures in 2 years costs $94. a) What must be the price of a 2-year coupon bond with a 5% coupon rate? (All face values 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.

One of your customers has just made a purchase in the

One of your customers has just made a purchase in the amount of $19,200. You have agreed to payments of $335 per month and will charge a monthly interest rate of 1.11 percent. How many months will it take for the account ...

On january 11998 the total assets of the mccue company were

On January 1,1998, the total assets of the McCue company were $270 million. The first present capital structure, which follows, is considered optimal. Assume that they have no short-term debt. Long-term debt              ...

A credit unions rate-climber gic pays rates of 2 6 and 8

A credit union's Rate-Climber GIC pays rates of 2%, 6%, and 8% compounded semiannually in successive years of a three-year term. How much interest will be earned in the second year, if $18,000 is invested in this GIC?

You are a new financial analyst for acme bank and funeral

You are a new financial analyst for Acme Bank and Funeral Directors (they decided to diversify). Anyway you are looking at the following for a company you are considering for a loan. Sales = $650,000, their operating pro ...

The business model for jpmorgan chase was change in 2008

The business model for JPMorgan Chase was change in 2008. Could the upside of the strategy have been achieved without exposing JPMorgan Chase the bank?

  • 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

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As