Net present value:a) is greater if cash receipts occur later rather than earlier.b) is greater if cash receipts occur earlier rather than later.c) is revenue minus fixed cost.d) is preferred over break-even analysis.c) is greater if $100 monthly payments are received in alump sum ($1,200) at the end of the year.

Net present value:a) is greater if cash receipts occur later rather than earlier.b) is greater if cash receipts occur earlier rather than later.c) is revenue minus fixed cost.d) is preferred over break-even analysis.c) is greater if $100 monthly payments are received in alump sum ($1,200) at the end of the year.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 5R: Suppose the company has just the opposite news and now expects unit sales for August, September, and...

See similar textbooks

Similar questions

An estimate has the following cost and revenue cash flows. The cash flows are assumed to occur at the end of the year. (a) If interest is 10%, find the net present worth, net future worth, and net annual equivalentworth.(b) Find the rate of return. (Hint: The guessing range is 25 to 30%).(c) Present a summary of the four methods Year Cost Revenue 0 $800 $0 1 - $450 2 - $425 3 - $400
The Fleming Manufacturing Company is considering a new investment. Financial projections for the investment are tabulated below. The corporate tax rate is 23 percent. Assume all sales revenue is received in cash, all operating costs and income taxes are paid in cash, and all cash flows occur at the end of the year. All net working capital is recovered at the end of the project. Year O Year 1 Year 2 Year 3 Year 4 $27,000 Investment Sales revenue $ 14,000 $ 14,500 $15,000 $12,000 Operating costs Depreciation Net working capital spending 2,400 6,750 ? 3,200 3,000 6,750 380 3,100 6,750 6,750 330 430 330 a. Compute the incremental net income of the investment for each year. (Do not round intermediate calculations.) Year 1 Year 2 Year 3 Year 4 Net income b. Compute the incremental cash flows of the investment for each year. (Do not round intermediate calculations. A negative answer should be indicated by a minus sign.) Year 0 Year 1 Year 2 Year 3 Year 4 Cash flow ( Prev 2 of 10 Next >
Consider a loan of $10,000 and the following pattern of cash flows. a. What is the interest rate that makes the present worth equal to $0.00? b. Using the interest rate determined in part (a), and leaving the −$10,000 at year 0 in place, determine the equal annual incomes that are equivalent to the gradient series in years 1, 2, 3, and 4?
Suppose (1) re-finance rate remains constant, (2) all cashflows are incurred in the end of the year, (3) re-investment rate increases by 10% a year, and (4) the inflation rate is constant at 2% a year. For MIRR, please use MIRR formula (not excel function) to caluclate MIRR. year cashflow -5000 1 2000 2 1000 1000 4 1000 2000 6. 500 7 -100 Refinance rate 5% reinvestment rate10% inflation rate 2% discount rate 7% MIRR
Consider the following cash flow profile: Suppose the positive-valued cash flows are now replaced by a geometric series. If the cash flow at end of year 1 is $10,000, what geometric rate is required for the cash flow profiles to be equivalent? Interest is at a compounded annual rate of 6%.
Given: Cash transactions as shown in cash flow diagram. %24 g = 4%/yr (positive transactions decreases from year to year) i = 10% per year 1 3 4. 5 7 12 13 14 15 Yrs g = 5%/yr (negative transactions become more negative) Required: (i) The net equivalent value at year 0 (Po)
3. follows: Carnegie Corp. projects an annual cash flow for one of its divisions as Year 0 1 2 3 4 5 6 Cash flow (SM) 3 0 -10 2 2 2 2 What is the IRR for this cash flow stream? Try plotting the NPV as a function of the discount rate. Are there any problems with using IRR for this application?
Solve, a. Calculate the IRR for each of the three cash-flow diagrams that follow. Use EOY zero for (i) and EOY four for (ii) and (iii) as the reference points in time. What can you conclude about “reference year shift” and “proportionality” issues of the IRR method? b. Calculate the PW at MARR=10 % per year at EOY zero for (i) and (ii) and EOY four for (ii) and (iii). How do the IRR and PW methods compare?
1
Use the following to determine FCF (Free Cash Flow) for the current year. Assume an effective tax rate of 25%: Revenue COGS (Cost of Goods Sold) Gross Profit Wages Expense Rent and Other Occupancy Expense Depreciation Expense Operating Income Current Assets Accounts Receivable Inventory Total Current Assets Gross Fixed Assets (at historical cost) less: Accumulated Depreciation Net Fixed Assets Total Assets Current Year 100,000 67,000 11,500 15,000 1,000 8,500 5,500 50,000 30,000 20,000 Prior Year 4,200 950 8,200 6,000 46,000 29,000 17,000 Current Liabilities Accounts Payable Wages Payable Enter your answer as a monetary amount rounded to four decimal places, but without the currency symbol. For example, if your answer is $90.1234, enter 90.1234. Show a decrease as a negative figure. Type your answer... 4,500 900
refer to below table ,Conduct a sensitivity analysis to determine the sensitivity of NPV to changes in the sales price, number of units sold, the variable costs per unit, fixed costs and the cost of capital. Set these variables’ values at 10% above and 10% below their base-case values. 2. Include a graph in your analysis with below table? 10% above Year Net Cash Flow (RM) Discount Rate (13.20%) Present Value (RM) 0 -1,217,800.00 1 -1217800 1 328,750.00 0.883392 290415.19 2 337,330.00 0.780382 263246.2 3 346,423.15 0.689383 238818.31 4 355,195.10 0.608996 216312.32 5 614,461.20 0.537982 330569.16 NPV 121561.19 10% below Year Net Cash Flow (RM) Discount Rate (10.80%) Present Value (RM) 0 -1,145,800.00 1 -1145800 1 184,000.00 0.902527 166064.98 2 185,395.00 0.814555 151014.45 3 189,459.85 0.735158 139282.93 4 193,936.89 0.6635 128677.14 5 448,143.25 0.598827 268360.17…
Required information Consider the cash flows shown. Year Revenues, $ Costs, $ 1 2 O 25,000 19,000 -6,000 -30,000 -7,000 NOTE: This is a multi-part question. Once an answer is submitted, you will be unable to return to this part. The spreadsheet function is (Click to select) Determine the external rate of return using the MIRR method if ir = 18% per year and i = 10% per year. Verify your answer with the spreadsheet function. The external rate of return is 3 4,000 -4,500 % per year.