uring the initial cash outflow? For payback period calppack period for project A?i Data Tablend to one decimal place.)(Click on the following icon in order to copy its contents into a spreadsheet)Cash FlorB.$15,000S7,500S7.500S7,500S7.500S7,500S7.500$90,000$36,000$27,000$18,000$9,000SOCostCash flow year 1Cash flow year 2Cash flow year 3Cash flow year 4Cash flow year 5Cash flow year 6$0PrintDone Payback period. Given the cash flow of two projects-A and B-in the following table, Eperiod for recapturing the initial cash outflow? For payback period calculations, assume that the cash flow is equally distributed over the year.and using the payback period decision model, which project(s) do you accept and which project(s) do you reject if you have a 3-year cutoffWhat is the payback period for project A?years (Round to one decimal place)

Payback period. Given the cash flow of two projects-A and B-in the following table, . and using the payback period decision model, which project(s) do you accept and which project(s) do you reject if you have a 3-year cutoff period for recapturing the initial cash outflow? For payback period calculations, assume that the cash flow is equally distributed over the year.

Payback period. Given the cash flow of two projects-A and B-in the following table, . and using the payback period decision model, which project(s) do you accept and which project(s) do you reject if you have a 3-year cutoff period for recapturing the initial cash outflow? For payback period calculations, assume that the cash flow is equally distributed over the year.

Entrepreneurial Finance

6th Edition

ISBN:9781337635653

Author:Leach

Publisher:Leach

Chapter6: Managing Cash Flow

Section: Chapter Questions

Problem 9DQ

See similar textbooks

Similar questions

The XNPV function can calculate NPV for any (possibly irregular) series of cash flows. Look this function up in Excel’s online help. Then use it to develop a spreadsheet model that finds the NPV of the following series: a payment of $25,000 today (assumed to be June 15, 2017), and cash inflows of $10,000 on March 1, 2018; $15,000 on September 15, 2018; $8000 on January 20, 2019; $20,000 on April 1, 2019; and $10,000 on May 15, 2019. Discount these back to “today” using a discount rate of 12%
Which of the following machine to be selected based on The average rate of return. with clear steps Sr. Machine A Machine B No. RO. RO. Year Cash outflow/ Cash outflow/ Cash inflow Cash inflow 0 (50,000.00) (50,000.00) 1 6,000.00 15,000.00 2 7,200.00 17,500.00 3 7,350.00 18,000.00 4 8,200.00 5,000.00 5 9,820.00 - 6 10,200.00 - 7 12,500.00 - 61,270.00 55,500.00
What is the internal rate of return for the following set of cash flows?Year Cash Flow0 -$60,0001 20,0002 20,0003 40,0004 40,000 Do not answer in excel format. Please give formula/handwritten or TI-84 calculator method
For each of the following problems, (a) draw the cash flow diagram; (b) present clean and clear manual solutions to the problem; (c) highlight the final answer (only the final answer as required by the problem) by enclosing it within a box. A cash flow sequence starts in year 1 at $5,000 and increases by $200 each year through year 10. Determine the present worth of the sequence. Use an interest rate of 10%.
Consider a project with the following cash flows: Time 0 1 2 3 4 5 CF -$5,000 $5,000 $4,000 $2,000 $1,000 -$6,000 Please round your answer to two decimal places. (e.g. 12345.67 for $12,345.67; 12.34 for 12.34%) a) To calculate the MIRR, find the modified cash flow at year 5 b) What does excel (or your calculator) say the IRR is?
Spreadsheet Link What is the IRR of the following project?Cash FlowYear0 -32,0001. 9,0002. 10,0003. 15,0004. 7,800 1). 10.8% 2). 11.2% 3). 11.7%4). 12.0% 5). 12.3%
Direction: Solve what is being asked and show your complete and neat solution. (ROUND OF PV FACTORS TO 4 DECIMAL PLACES, ROUND OF FINAL ANSWER TO TWO DECIMAL PLACES. IN MCQs CHOOSE THE BEST ANSWER) D.) The frequency of spending or the rate or turnover of money a. Demand for money b. Velocity of money c. Transaction demand d. Speculative demand E.) Is a contractual financial product sold by financial institutions that is designed to accept and grow funds from an individual and then, upon annuitization, pay out a stream of payments to the individual at a later point in time. a. Annuity b. Demand c. Speculation d. Investment
Can you tell me how to get the 0% to 25% rate numbers? I have to plot the NPV profiles. Year Project A Discounted cashflow Discounted cashflow 0 -50,000 -$50,000.00 -$50,000.00 1 25,000 $22,727.27 $23,584.91 2 20,000 $16,528.93 $17,799.93 3 10,000 $7,513.15 $8,396.19 4 5,000 $3,415.07 $3,960.47 5 5,000 $3,104.61 $3,736.29 NPV $3,289.02 $7,477.79 IRR 14% 14% 10% 6% Year Project B Discounted cashflow Discounted cashflow 0 -50,000 -$50,000.00 -$50,000.00 1 15,000 $13,636.36 $14,150.94 2 15,000 $12,396.69 $13,349.95 3 15,000 $11,269.72 $12,594.29 4 15,000 $10,245.20 $11,881.40 5 15,000 $9,313.82 $11,208.87 NPV $6,861.80 $13,185.46 IRR 15% 15% Rate Project A Project B 0% 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 16% 17% 18% 19% 20% 21% 22% 23% 24% 25%
Project A requires an initial outlayat t = 0 of $1, 000, and its cashflows are the same in Years 1.through 10. Its IRR is 17%, andits WACC is 9%. What is theproject's MIRR? Do not roundintermediate calculations. Roundyour answer to two decimalplaces.
Calculate the internal rate of return for a $300.0m cash outflow at the end of year 0 and a $716.0m cash inflow at the end of year 5. 16% 20% 18.5% 19%
Task 2A business has two projects to invest in, as follows:Create a new spread sheet, calculate NPV for the following projects at discount rates of 3% and 7%, respectively, by creating a dynamic process. Project 1 Project 2Year Cash inflows Cash outflows Cash inflows Cash outflows0 0.00 70,000.00 0.00 70,000.001 24,000.00 13,000.00 25,000.00 15,000.002 22,000.00 1,000.00 25,000.00 03 25,000.00 0 20,000.00 04 25,000.00 0 43,000.00 21,000.005 17,500.00 7,500.00 20,000.00 5,000.00 P1: NPV P2: NPVThen, a) by using a built-in/Excel function, calculate the NPV for each project with discount rates of 3% and 7%, respectively;b) By comparing the NPVs at the rate of…
What is the payback period for the following set of cash flows? (Round answer to two decomals, i.e. 32.16) Period Cash Flow 0 -6700 1 2200 2 3800 3 1000 4 4000