Please use formulas and hand-work, it helps me better understand
as I cannot use excel

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
Please use formulas and hand-work, it helps me better understand as I cannot use excel Problem...
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 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 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!
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. Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 20% each of the last three years. Casey is considering a capital budgeting project that would require a $3,500,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company’s discount rate is 16%. All...
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 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, 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 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 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%?