Why does net working capital appear with both negative and positive values in Figure 13-2? FIGURE 13-2
Question:
Why does net working capital appear with both negative and positive values in Figure 13-2?
Transcribed Image Text:
FIGURE 13-2 Analysis of an Expansion Project: Cash Flows and Performance Measures (Thousands of Dollars) B C D E F G H 82 Part 2. Cash Flows and Performance Measures 83 Scenario: Base-Case 84 Intermediate Calculations 0 1 2 3 4 85 Unit sales 86 Sales price per unit 87 Variable cost per unit (excl. depr.) 10,000 11,500 13,225 15,209 $1.50 $1.56 $1.62 $1.69 $1.07 $1.10 $1.14 $1.17 88 Nonvariable costs (excl. depr.) $2,120 $2,184 $2,249 $2,317 89 Sales revenues Units x Price/unit $15,000 $17,940 $21,456 $25,662 90 NOWC-15% (Revenues...) $2,250 $2,691 $3,218 $3,849 $0 91 Basis for depreciation $7,750 92 Annual depreciation rate (MACRS) 33.33% 44.45% 14.81% 7.41% 93 Annual depreciation expense $2,583 $3,445 $1,148 $574 94 Remaining undepreciated value (book value) $5,167 $1,722 $574 $0 95 Cash Flow Forecast Cash Flows at End of Year 96 97 Sales revenues= Units Price/unit 0 1 2 $15,000 $17,940 3 $21,456 4 $25,662 98 Variable costs = Units Cost/unit $10,700 $12,674 $15,013 $17,782 103 Net operating profit after taxes 99 Nonvariable costs (excluding depr.) 100 Depreciation 101 Earnings before int. and taxes (EBIT) 102 Taxes on operating profit (40% rate) 104 Add back depreciation $2,120 $2,184 $2,249 $2,317 $2,583 $3,445 $1,148 $574 -$403 -$363 $3,047 $4,988 -$161 -$145 $1,219 $1,995 -$242 -$218 $1,828 $2,993 $2,583 $3,445 $1,148 $574 105 Equipment purchases -$7,750 106 Salvage value $639 107 Cash flow due to tax on salv. val. -$256 108 Cash flow due to change in WC -$2,250 -$441 -$527 -$631 $3,849 109 Opportunity cost, after taxes 110 After-tax externalities 111 Project net cash flows: Time Line 112 Project Evaluation Measures $0 $0 $0 $0 $0 $0 $0 $0 $0 -$10,000 $1,900 $2,700 $2,345 $7,800 113 NPV $1,048 =NPV(E69,F111:1111)+E111 114 IRR 13.79% IRR(E1111111) 115 MIRR 12.78% MIRR(E111:1111,E69,E69) 116 Profitability index 1.10 =NPV(E69,F111111)/(-E111) 117 Payback 3.39 =PERCENTRAN K(E120:1120,0,6)*1119 118 Disc. payback 3.80 =PERCENTRANK(E122:1122,0,6)*1119 119 Calculations for Payback 120 Cumulative cash flows for payback 121 Disc. cash flows for disc. payback 122 Cumulative discounted cash flows Year: 0 1 2 3 4 -$10,000 -$8,100 -$10,000 $1,727 -$10,000 -$8,273 -$5,400 -$3,055 $4,745 $2,231 $1,762 $5,328 -$6,041 -$4,279 $1,048
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 0% (1 review)
Answered By
Nandana Wijayarathna
I am a highly experienced writer in several areas,
Business management
Information technology
Business administration
Literature
Biology
Environmental science
History
4.50+
161+ Reviews
399+ Question Solved
Related Book For
Intermediate Financial Management
ISBN: 9781337395083
13th Edition
Authors: Eugene F. Brigham, Phillip R. Daves
Question Posted:
Students also viewed these Business questions
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
"internet radios" for streaming audio, and personal video recorders and players. Describe design and evaluation processes that could be used by a start-up company to improve the usability of such...
-
(a) Explain how a limit worth may be tended to at run-time, both in a syntaxtree middle person and in collected code. What is the importance word "settled" already? [3 marks] (b) Give a model program...
-
1. The following are selected accounts taken from the adjusted trial balances of the Purell Merchandise company on December 31, 2021: Inventory, January 1, 2021 Selling expenses Loss on sale of...
-
The CM of an empty 1250-kg car is 2.40 m behind the front of the car. How far from the front of the car will the CM be when two people sit in the front seat 2.80 m from the front of the car, and...
-
Companys record of transactions concerning part X for the month of April was as follows. Instructions (a) Compute the inventory at April 30 on each of the following bases. Assume that perpetual...
-
Defendant Kenneth Blake was married to Charlene Hinton-Blake, who died in 2012. Three of Hinton-Blakes sisters, including Yvonne Hinton, assisted her with day-to-day care during a four-year period of...
-
Presented below are the trial balance and the other information related to Yorkis Perez, a consulting engineer. 1. Fees received in advance from clients $6,000.2. Services performed for clients that...
-
As an example of how simulation can be used for operations research, consider the following college enrollment model. A certain college wants to analyze the effect of admissions and freshman...
-
Describe a process that firms often use to determine a projects risk-adjusted costs of capital.
-
How could the analysis in Figure 13-2 be modified to consider cannibalization, opportunity costs, and sunk costs? FIGURE 13-2 Analysis of an Expansion Project: Cash Flows and Performance Measures...
-
Ethridge Co. of Atlanta, Georgia, has a subsidiary in India that produces products and sells them throughout Asia. In response to the September 11, 2001, terrorist attack on the United States,...
-
A taxpayer makes $45,000 in salary for TY2023. During the year, his employer gives him a reimbursement for moving across the country in the amount of $10,000. His current withholding is with the...
-
What is the difference between net present value and internal rate of return?
-
what is the answer Warren proposes a tax on the monetary lobbying efforts and contributions of corporations and interest groups to limit their influence. Why is this unlikely to completely limit the...
-
Recall that if p = C[t] and p(t) = adtd + ad1td1 + ... + art + ao, then for A M, (C) we define p(A) = adAd + ad-1Ad-1 + ... + aA + aoln. For this problem, fix p C[t] and A Mn(C). (i) If A is an...
-
Why is the Statement of Owner's Equity prepared after the Income Statement?
-
Cylindrical dry-bulb and wet-bulb thermometers are installed in a large-diameter duct to obtain the temperature T , and the relative humidity x of moist air flowing through the duct at a velocity V....
-
Suppose you are comparing just two means. Among the possible statistics you could use is the difference in means, the MAD, or the max min (the difference between the largest mean and the smallest...
-
a. What assets are excluded from capital asset status? b. Are capital gains given favorable tax treatment? c. What is the significance of an asset being classified as a capital asset? d. Are capital...
-
Is there any tax advantage for an individual who has held an appreciated capital asset for eleven months to delay the sale of the asset? Explain.
-
a. Explain the difference between income splitting and income shifting. b. Why are taxpayers interested in shifting income from one tax return to another within the same family or economic unit? c....
-
What percentage of the American opportunity tax credit may be refundable?
-
You want to buy a house. You have $50,000 saved for the down payment and can pay $2,000 per month on the mortgage. The 30-year mortgage interest rate is 9% per year (equal to 0.75% per month). What...
-
Compute the Social Security and Medicare for Paul, Alex, and Andrea. The rates are 6 . 2 % for Social Security and 1 . 4 5 % for Medicare. Assume the Social Security limit is $ 1 4 2 , 8 0 0 and the...
Study smarter with the SolutionInn App