Question

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%?

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

Present value of annuity received at the beginning of each year = Amount + Amount*PVAF(r%, n-1 periods)

Hence, present value of $50 to be received at the BEGINNING of each year for the next 5 years

= 50 + 50*PVAF(11%, 4 years)

= 50 + 50*3.102

= $205.1

Future Value of annuity received at the beginning of each year = (1+r)*P[{(1+r)n-1}/r]

= (1+0.11)*50[{(1+0.11)5-1}/0.11]

= $345.64

Add a comment
Know the answer?
Add Answer to:
Please use hand work and formulas, as I cannot use excel and it helps me better...
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 formulas and hand-work, it helps me better understand as I cannot use excel Problem...

    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%?

  • 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 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...

  • 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...

  • 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...

  • Please Do NOT USE excel to solve .... Show me the steps and the equations to...

    Please Do NOT USE excel to solve .... Show me the steps and the equations to better understand the question You have a habit of drinking a cup of coffee ($2.00 a cup) on the way to work every morning for 30 years. If you put the money in the bank for the same period, how much would you have, assuming your accounts earns 5% interest compounded daily. a) If we would like to use N=30 years, Find the equivalent...

  • Bond and Stock Value and Evaluation. PLEASE SHOW ALL FORMULAS/EQUATIONS AND SHOW ALL OF YOUR WORK. Do not use Excel....

    Bond and Stock Value and Evaluation. PLEASE SHOW ALL FORMULAS/EQUATIONS AND SHOW ALL OF YOUR WORK. Do not use Excel. 4. The company yesterday paid their annual dividend of $2.00 and the expected price in 2 years is $100. The dividend payment is expected to grow at 7 %. i) What is the stock's required return? ii) what is the price today? Use annual compounding

  • Calculate the following four problems using interest tables, formulas, excel and the calculator. Thus, each problem...

    Calculate the following four problems using interest tables, formulas, excel and the calculator. Thus, each problem (1 to 4) should be completed using four different methods. Please show all work for each of the four methods for each problem on the same excel sheet(s). 1) Determine the future value of $100,000 at 4% for 6 years 2) Determine the present value of $100,000 at 6% for 4 years 3) If you are to receive $7,419 each year (ordinary annuity) for...

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