Question: Please show answer in excel with formulas 2. Using a discount rate of 9.6% APR, compounded monthly, calculate the present value of a monthly perpetuity

Please show answer in excel with formulas 2. Using a discount

Please show answer in excel with formulas

2. Using a discount rate of 9.6% APR, compounded monthly, calculate the present value of a monthly perpetuity con- sisting of $5250 payments if: (a) the first payment is made today (2 pts.), (b) the first payment is made one month from now (2 pts.), and (c) the first payment is made 40 months from now (2 pts.)

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 Finance Questions!

5. Using a discount rate of 4.8% APR, compounded monthly, calculate the present value of a monthly perpetuity pay ment of $5250 if: (a) the first payment is made one month from now (2 pts.), (b) the...

Question 2 Your firm agrees to a contract where you will be paid $50,000 in 9-months when a project is completed. If the discount rate is 6% APR compounded monthly, what is the present value of the...

can you please answer #45 and #56? it is from the same document from before. Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement...

please see question 53 about the amount owed in taxes the following year. Exam Name___________________________________ MULTIPLE CHOICE. Choose the one alternative that best completes the statement or...

1.Calculating OCF Ranney, Inc., has sales of $14,900, costs of $5,800, depreciation expense of $1,300, and interest expense of $780. If the tax rate is 40 percent, what is the operating cash flow, or...

Below are the questions, I don't know why it says question options because there are none, but please pay attention to the decimal options that are needed. I need this asap. Question 1 (1 point) The...

I NEED ASAP HELP! I WILL RATE !! :) Thank you for your help! Solve the following problems using Excel spreadsheet (Excel templates can be found on Canvas under Assignments HW3>HW3 Excel Template.")...

A car dealership offers you no money down on a new car. You may pay for the car for 5 years by equal monthly end-of-the-month payments of $807 each, with the first payment to be made one month from...

i am taking Cooperate finance which is FIN222 can help me to answer.. ? Tutorial 1 Topic 1 Chapter 1 4. What are the main advantages and disadvantages of organising a firm as a corporation? 6. You...

Please show work in excel with appropriate formulas (Please do not just copy/paste in cells) Thank you Page 1 of 5 Date: 11/7/16 Course: Managerial Finance Week3 Problem Set 1. Your bank is offering...

Show how to simulate Cauchy random variables using the probability integral transformation.

One end of a uniform rod of mass m and length / is clamped. The rod lies on a smooth horizontal surface and rotates on it about the clamped end at a uniform angular velocity . The force exerted by...

Gareths budget per week 250 1/2 rent 12.5%bills 27,5%food per week 3/4 by net food on savings how long will it take Gareth to save 900 from leftover

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".