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%?
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
Please use hand work and formulas, as I cannot use excel and it helps me better...
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 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!
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 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 $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 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...
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 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.
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