Question: if possible could this be shown on excel thank you! An annuity pays $325,000 in 1 year and has a 2% growth rate. The annuity

if possible could this be shown on excel thank you!

An annuity pays $325,000 in 1 year and has a 2% growth rate. The annuity lasts 20 years and the prevailing market rate is 5%. What is the PV of the annuity? $5.467 million $6.669 million $4.766 million $6.750 million

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!

Turbine blades mounted to a rotating disc in a gas turbine engine are exposed to a gas stream that is at T = 1200C and maintains a convection coefficient of h = 250 W/m2 K over the blade. The...

Q1. Calculate the future value of each following pattern of cash flows: a) You deposit $12,500 today into a 10 year term deposit. The investment pays a 6.5% annual interest rate, compounding...

solve in excel form Q4. (a) How much would you invest today to receive $7,500 at the end of each year for the first five years, then $9.000 per year for the following four years? Assume an annual...

Please provide the answer in order 1 to 50, matching question 1 with answer 1 and so long. D D A rm produces and sells two products, Plus and Max. The following information is available relating to...

plz answerr question 3 only those are the questions before it, but i only need answer for question 3. dont report this request as multipe questions :) thank you Question 3: There are many aspects...

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

Complete the following problems from Chapter 12 in Financial Management: Theory and Practice : Chapter 12: Topics: Additional Funds Needed, Forecasted Statements and Ratios, Financing Deficits...

I need, I am working on GENERAL ELECTRIC AND UNITED TECHNOLOGIES CORP, I need help GE and UTC Financial Statements Forecast for the next 5 year using the attachment. Throughout this course you will...

123please help me with this Winter 1, 2013 7/22/2012 Chapter 4. Ch 04 P35 Build a Model Except for charts and answers that must be written, only Excel formulas that use cell references or functions...

Hello, I have assessment.. Step 1 : Calculate the following ratios for the latest five years using the O-S Checklist Approach, an Excel template . For an overview of the approach, read our article,...

Can anyone solve the answers from the given document givenbelow? I really need help. MY FINAL LITERALLY IS KNOCKING AT THE DOOR. Name_________________________________ Student...

Design a filter for an analog communication circuit that requires to remove the signal frequency above 72 kHz with a passband gain of 1.5 and a roll off of -40 dB/decade (Assume C=0.001uF]. Compare...

Let f (x) be the function shown in Figure 27. 1. Find the domain and range of f (x)? 2. Sketch the graphs of f (2x), f(1/2x), and 2f (x). 3. Extend the graph of f (x) to [4, 4] so that it is an even...

Problem 1 0 - 7 Stock Market Bubble ( LG 1 0 - 5 ) The NASDAQ stock market bubble peaked at 5 , 2 7 5 in 2 0 0 0 . Two and a half years later it had fallen to 1 , 3 0 0 . What was the percentage...

The times in the table are in minutes. Demand forecasts indicate a need to operate with a cycle time of 1 1 minutes. \ table [ [ Activity , \ table [ [ Activity ] , [ Description ] ] , \ table [ [...

4.8 A salesperson contacts 20 people each day and requests that they purchase a specific product. Should the number of daily purchases be analyzed using discrete or continuous probability models?

4.5 List four examples of discrete random variables that could be observed in a new consulting business.

4.6 Define three continuous random variables that a marketing vice president should regularly examine.