Question

Please use formulas and hand-work, it helps me better understand as I cannot use excel
Problem 2 What are the present value and future value of S900 to be received at the END of each year for the next 5 years if the discount/compounding is 7%?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Annual Payment = $900
Interest Rate = 7%
Number of Payments = 5

Present Value = Payment / (1 + Interest Rate)^Period

Present Value of Annuity = $900/1.07 + $900/1.07^2 + $900/1.07^3 + $900/1.07^4 + $900/1.07^5
Present Value of Annuity = $900 * (1 - (1/1.07)^5) / 0.07
Present Value of Annuity = $900 * 4.10020
Present Value of Annuity = $3,690.18

Future Value = Payment * (1 + Interest Rate)^Period

Future Value of Annuity = $900*1.07^4 + $900*1.07^3 + $900*1.07^2 + $900*1.07 + $900
Future Value of Annuity = $900 * (1.07^5 - 1) / 0.07
Future Value of Annuity = $900 * 5.75074
Future Value of Annuity = $5,175.67

Add a comment
Know the answer?
Add Answer to:
Please use formulas and hand-work, it helps me better understand as I cannot use excel Problem...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Please use hand work and formulas, as I cannot use excel and it helps me better...

    Please use hand work and formulas, as I cannot use excel and it helps me better understand. Problem 1 What are the present value and future value of $50 to be received at the BEGINNING of each year for the next 5 years if the discount/compounding is 11%?

  • Please use hand work and formulas as I cannot use excel and it helps me better...

    Please use hand work and formulas as I cannot use excel and it helps me better understand. Thank you! Assets Cash and Marketable Securities Accounts Receivable Inventories Total Current Assets Net plant and equipment TOTAL ASSETS 2017 130 4875 7995 13000 13000 26000 2016 1040 4095 5395 10530 11310 21840 Liabilities and Equity Accounts Payable Notes Payable Accruals Total Current Liabilities Long Term Bonds TOTAL DEBT Preferred Stock Common Stock Retained earnings TOTAL COMMON EQUITY TOTAL LIABILITIES AND EQUITY 2017...

  • PLEASE HELP ME UNDERSTAND THIS PROBLEM IN EXCEL WITH ALL THE EXCEL FORMULAS. Annual cash inflows...

    PLEASE HELP ME UNDERSTAND THIS PROBLEM IN EXCEL WITH ALL THE EXCEL FORMULAS. Annual cash inflows that will arise from two competing investment projects are given below:      Year Investment A Investment B 1 $ 5,000       $8,000       2 6,000       7,000       3 7,000      6,000       4 8,000       5,000       Total $26,000       $26,000       The discount rate is 9%. Required: Compute the present value of the cash inflows for each investment. Each investment opportunity will require the same initial investment. (Use Microsoft Excel...

  • Please use hand work and formulas as it helps me better understand. Thank you so much!...

    Please use hand work and formulas as it helps me better understand. Thank you so much! Assets Cash and Marketable Securities Accounts Receivable Inventories Total Current Assets Net plant and equipment TOTAL ASSETS 2017 130 4875 7995 13000 13000 26000 2016 1040 4095 5395 10530 11310 21840 Liabilities and Equity Accounts Payable Notes Payable Accruals Total Current Liabilities Long Term Bonds TOTAL DEBT Preferred Stock Common Stock Retained earnings TOTAL COMMON EQUITY TOTAL LIABILITIES AND EQUITY 2017 780 1820 1430...

  • Use excel and show formulas. Follow instructions “by hand” & by function. The future value of...

    Use excel and show formulas. Follow instructions “by hand” & by function. The future value of $750,000 invested today after seven years with an annual interest rate of 7%, but with daily compounding interest paid every month).

  • Calculate the following time value of money problem using Microsoft® Excel® Please show your work in...

    Calculate the following time value of money problem using Microsoft® Excel® Please show your work in the cells. Use Excel formulas instead of writing the values/answers directly in the cell. 2) What is the present value of $992 to be received in 13.5 years from today if our discount rate is 3.5 percent? PV=FV x [ 1/(1+r)n ] Future Value (FV) 992 Interest Rate (i) 0.035 Number of years (n) 13.5 Answer-

  • please do the work by hand, use the formula from the formula sheet 17. Hand Clapper,...

    please do the work by hand, use the formula from the formula sheet 17. Hand Clapper, Inc. is considering a 4-year project to manufacture clap-command garage door openers. The project requires an initial investment of $18 million in machinery that will be depreciated using 3-year MACRS. The 3-year MACRS depreciation rates by year are Year 1 - 33.33%; Year 2 - 44.45%; Year 3 - 14.81%; and Year 4: 7.41%. The machinery will have no salvage value at the end...

  • What are the PRESENT and FUTURE value of $900 to be received at the END of...

    What are the PRESENT and FUTURE value of $900 to be received at the END of each year for the next 5 years if the discount / compounding is 7%? Please show work.

  • please show excel formulas so I can understand the problem thanks 9-59 Two equipment investments are...

    please show excel formulas so I can understand the problem thanks 9-59 Two equipment investments are estimated as follows: Year A 0 -$15,000 $18,000 5,000 6,500 5,000 6,500 5,000 6,500 5,000 6,500 5,000 6,500 Which investment has the better discounted payback period if i = 14%?

  • Please show formulas and work. No excel formulas please. Problem 1 You take out an amortized...

    Please show formulas and work. No excel formulas please. Problem 1 You take out an amortized loan for $10,000. The loan is to be paid in equal installments at the end of each of the next 5 years. The interest rate is 8%. Construct an amortization schedule. Problem 2: A. Calculate the PV of $100 due in 5 years compounded daily at 12%. B. Calculate the FV of $1000 due in 3 years at 6% compounded quarterly. C. Calculate the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT