How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Steve Your Own Question

Steve
Steve, MBA
Category: Homework
Satisfied Customers: 23198
Experience:  MBA
26942375
Type Your Homework Question Here...
Steve is online now
A new question is answered every 9 seconds

Please show in Excel how this is done Given a 10 percent

Resolved Question:

Please show in Excel how this is done

Given a 10 percent discount rate, what is the present value of a perpetuity of $1000 per year if the first payment does not begin until the end of year 10
Submitted: 4 years ago.
Category: Homework
Expert:  Steve replied 4 years ago.

*

PLEASE NOTE THAT EXPERTS ARE ONLY COMPENSATED WHEN THE ACCEPT BUTTON IS PRESSED

 

.

 

JUSTANSWER IS AN HONOR SYSTEM AND EXPERTS ARE ONLY COMPENSATED WHEN THE ACCEPT BUTTON IS PRESSED

 

.

 

EVEN IF YOU ARE ON A SUBSCRIPTION WITH UNLIMITED OR MULTIPLE QUESTIONS ACCEPT STILL NEEDS TO BE CLICKED TO CREDIT YOUR EXPERT

 

THANK YOU

 

 

 

*

*

*

*

 

 

 

 

Before reading my answer below, please note that I do not receive any credit or compensation whatsoever for my time and effort until the green ACCEPT button is pressed. Thank you.

 

 

Please consider a tip/bonus if satisfied.

 

Here is your answer: CLICK HERE and then press "download"

 

Please let me know if you have further questions.


If I have answered your question, I would kindly ask that you please press the green "ACCEPT" button so that I receive credit for doing so.

 

>>>>>PLEASE DO NOT FORGET TO PRESS ACCEPT <<<<<

 

thank you in advance.

 

Steve

Customer: replied 4 years ago.
Steve,

Can you lay it out, plugging in the numbers and utilizing the function (FX) keys in Excel?

Thank you!
Expert:  Steve replied 4 years ago.

Hi again, please do not forget to press ACCEPT as this is the only way I receive credit for my answer - thanks!

 

I do not know what you are referring to.

 

The full equation is shown in the cell. Please let me know if there is something else you need. The full calc is shown in my answer.

 

 

Please let me know if you have further questions.

 

If I have answered your question, I would kindly ask that you please press the green "ACCEPT" button so that I receive credit for doing so.

>>>>>PLEASE DO NOT FORGET TO PRESS ACCEPT <<<<<

 

thank you in advance.

Steve

Customer: replied 4 years ago.
There are function keys in excel for present value, etc. You plug them in the formula bar and a formula box will come up.
Expert:  Steve replied 4 years ago.
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.
Steve and 6 other Homework Specialists are ready to help you

Related Homework Questions