Question: Please help me! Using the excel tools, find the factor (P/A 1 ,4.5%,8.0%,8). What amount of equal end of period payments is required to completely

Please help me!

  1. Using the excel tools, find the factor (P/A1,4.5%,8.0%,8).
  2. What amount of equal end of period payments is required to completely pay off a current loan balance amount of 23,000 if the interest rate applied is 8.0% and the desire is to finish payments 18 periods from now?
  3. An increasing amount cash flow has been projected for an investment in renewable energy.Based on an increases in the amount charged per unit of energy and growth in energy use, the payment of 3800 per period with the first payment one period from now is expected to increase by 300 each period thereafter for a total of 18 periods.Using a discount rate of 11.0 percent, what is the present worth of this payment stream?
  4. Royalties from a patent are expected to start at 15,000 per period beginning one period from now and to decline by 500 each period thereafter until the technology is withdrawn from the market 23 periods from now.What is the worth at the end of period 12 of this stream of payments both past and future using an interest rate of 8.00%?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!