Question: Need help plugging this into excel. What is the present value of the following annuity? $4,844 every year at the end of the year for

Need help plugging this into excel. What is the present value of the following annuity?

$4,844 every year at the end of the year for the next 11 years, discounted back to the present at 6.33 percent per year, compounded annually round the answer to two decimal places?

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!

help with putting into excel. What is the present value of the following annuity? $1,765 every quarter year at the end of the quarter for the next 9 years, discounted back to the present at 14.66...

You have decided to place $683 in equal deposits every month at the beginning of the month into a savings account earning 6.15 percent per year, compounded monthly for the next 3 years. The first...

How do i solve with financial calculator 1.Calculate the number of years it will take for X to save $50,000 assuming she can invest $1250 annually as an annuity due. The market interest rate is 8%....

Show how to enter into EXCEL 1. You have decided to place $153 in equal deposits every month at the beginning of the month into a savings account earning 4.69 percent per year, compounded monthly for...

1.You have decided to place $352 in equal deposits every month at the beginning of the month into a savings account earning 7.01 percent per year, compounded monthly for the next 11 years. The first...

4. What is the present value of the following annuity? $1,022 every half year at the end of the period for the next 8 years, discounted back to the present at 19.17 percent, compounded semiannually....

Round the answer to two decimal places. PLEASE SHOW EQUATIONS 1) What is the present value of the following annuity? $4,910 every half year at the end of the period for the next 10 years, discounted...

Need help with the following problem with the formula in excel. What is the present value of the following annuity? $4,991 every year at the end of the year for the next 8 years, discounted back to...

Next Page Page 6 of 6 This set of problems is designed to be calculated using the Excel or financial calculator. Do not use financial tables to calculate these problems. Question 6 (1 point) What is...

What is the present value of the following annuity? $3,926 every quarter year at the end of the quarter for the next 7 years, discounted back to the present at 12.58 percent per year, compounded...

Hydrogen atoms are placed in an external magnetic field. The protons can make transitions between states in which the nuclear spin component is parallel and anti parallel to the field by absorbing or...

On October 1, 2014, Pacer Corp. acquired all of Sunny Corp.s outstanding stock for cash. The fair value of Sunnys net assets was less than the purchase price but more than the net carrying amount....

The first step in a discounted - cash - flow analysis for a profit - seeking enterprise is to determine the Blank _ _ _ _ _ _ cash flows associated with the projects under consideration. Multiple...

describe the three roles of the human resource development specialist. ( Learning Specialist, Manager of HRD, and Consultant) Which of three roles or activities do you think general managers should...

2. I try to be as logical as possible

1. To understand the prerequisites for personal communication mastery.

2. To understand different focus areas for personal communication mastery.