Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

Pauline wonders what her monthly "principal and interest" payment would be under these circumstances. Use Excel spreadhseet )and the PMT Function) to help answer these questions:
A. What is the interest rate that should be entered into the PMT function?
B. What is the number of periods that should be entered into the PMT Function?
C. What is the amount that should be entered into the PMT Function?
D. What is the amount Pauline's monthly "prinicipal and interest" payment?
E. When Pauline makes her first payment, what amount will go to pay interest and what amount will be repayment of principal? (Hint: What amount did she owe during the first month and what rte of interest did she incur during the month?)

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M9271995

Have any Question?


Related Questions in Basic Finance

Supposenbspintels stock has an expected return of 220 and a

Suppose? Intel's stock has an expected return of 22.0% and a volatility of 23.0%?, while? Coca-Cola's has an expected return of 8.0% and volatility of 15.0%. If these two stocks were perfectly negatively correlated?(i.e. ...

A compare and contrast primary valuation alternatives

A) Compare and contrast primary valuation alternatives: historical costs (purchase price less accumulated depreciation), fair value (market price), and the mixed attributed measurement model. In your opinion which one re ...

Suppose a new ergonomic safety intervention cost 405000

Suppose a new ergonomic, safety intervention cost $405,000. Further suppose the intervention is certain to prevent all back injuries associated with the job. Over the last three years, the employer has averaged 14 injuri ...

Please show formula and detailed explanationyou have just

Please show formula and detailed explanation. You have just purchased an investment that generates the following cash flows for the next four years. You are able to reinvest these cash flows at 11.1 percent, compounded a ...

Franks is looking at a new sausage system with an installed

Franks is looking at a new sausage system with an installed cost of $375,000. This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped ...

In todays environment how could firms balance their

In today's environment, how could firms balance their marketing activities while meeting the demand of consumers from the main culture as well as from a subculture?

A plaintiff is suing the city for injuries sustained after

A plaintiff is suing the city for injuries sustained after a freak street sweeper accident. In the trial, doctors testified that it will be five years before the plaintiff is able to return to work. The jury has already ...

1 your firm expects to incur a 500k loss in year 1 and

1. Your firm expects to incur a ($500K) loss in year 1 and make $100K of net income in year 2 and $300K of net income in year 3. The retention ratio is projected to be 100%. The beginning equity balance on the balance sh ...

What is the payback period for the following set of cash

What is the payback period for the following set of cash flows (answer should include the fraction of the last year needed for a full payback)? What is the IRR? Year 0 = -256,000, Year 1 = 35,000, Year 2 = 77,000, Year 3 ...

A brewer is launching a new product brewed ginger ale with

A brewer is launching a new product: brewed ginger ale with a low alcohol content. The brewer plans to spend $3 million promoting this product this year, which is expected to expand its sales of this product to $12 milli ...

  • 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