NPV is supposed to be 22,146 can you explain ? 356~0002 2 4 7 8 9 10
Fantastic news! We've Found the answer you've been seeking!
Question:
NPV is supposed to be 22,146 can you explain ?
Transcribed Image Text:
356~0002 2 4 7 8 9 10 11 12 13 14 15 16 17 18 19 20 5222222222XXNXNNNNNN 21 23 24 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 A Capital Spending Cash Flows Net Working Capital Cash Flows Initial Investment Beginning Value m Operating Cash Flows Project Cash Flows Depreciation Rate (MACRS) Depreciation Ending Value Revenue Costs Capital Spending Cash Flows Beginning Balance Increase (Decrease) Ending Balance Net Working Capital Cash Flows Depreciation Operating Cash Flow Depreciation Operating Profit (EBIT) Taxes NOPAT D E ESTIMATING PROJECT CASH FLOWS 1 2 C 0 $ (126,000) $ (100,000) $ $ 126,000 $ $ (126,000) CAPITAL SPENDING CASH FLOWS - INVESTMENT, DEPRECIATION, AND SALE OF ASSET 0 1 2 3 $ 126,000 $ (3,090) (3,183) (3,278) 252,870 259,152 265,883 $ (226,000) $ 240,150 $ 249,780 $ 255,969 $ 262,605 0 100,000 100,000 $ (100,000) $ INPUTS & RISK ANALYSIS $ (3,000) 243,150 NET WORKING CAPITAL CASH FLOWS 0 2 $ $ 126,000 $ 113,400 $ 10.0% 18.0% 22,680 113,400 $ 90,720 $ 12,600 1 100,000 $ 3,000 103,000 (3,000) $ 103,000 3,090 106,090 F $ 3 (3,090) $ $ G 90,720 $ 14.4% 4 4 3,183 109,273 (3,183) $ $ 72,576 $ 11.5% 14,515 18,144 72,576 $ 58,061 $ Salvage Valu $ Gain (Loss) from Sale $ Tax $ $ After-tax Cash Flow $ $ 3 4 106,090 $ 109,273 $ 3,278 112,551 (3,278) $ H 5 300,361 112,551 273,026 685,938 5 58,061 9.2% 11,617 46,444 385,000 338,556 84,639 300,361 300,361 5 112,551 (112,551) 112,551 OPERATING CASH FLOWS 1 2 3 4 5 $ 1,500,000 $ 1,545,000 $1,591,350 $ 1,639,091 $1,688,263 1,215,400 1,251,862 1,289,418 1,328,100 1,180,000 12,600 22,680 18,144 14,515 11,617 307,400 306,920 321,344 335,157 348,546 76,850 76,730 80,336 83,789 87,136 230,550 230,190 241,008 251,368 261,409 12,600 22,680 18,144 14,515 11,617 $ 243,150 $ 252,870 $ 259,152 $ 265,883 $ 273,026 CASH FLOW DETERMINATION MACRS Depreciatic 356~0002 2 4 7 8 9 10 11 12 13 14 15 16 17 18 19 20 5222222222XXNXNNNNNN 21 23 24 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 A Capital Spending Cash Flows Net Working Capital Cash Flows Initial Investment Beginning Value m Operating Cash Flows Project Cash Flows Depreciation Rate (MACRS) Depreciation Ending Value Revenue Costs Capital Spending Cash Flows Beginning Balance Increase (Decrease) Ending Balance Net Working Capital Cash Flows Depreciation Operating Cash Flow Depreciation Operating Profit (EBIT) Taxes NOPAT D E ESTIMATING PROJECT CASH FLOWS 1 2 C 0 $ (126,000) $ (100,000) $ $ 126,000 $ $ (126,000) CAPITAL SPENDING CASH FLOWS - INVESTMENT, DEPRECIATION, AND SALE OF ASSET 0 1 2 3 $ 126,000 $ (3,090) (3,183) (3,278) 252,870 259,152 265,883 $ (226,000) $ 240,150 $ 249,780 $ 255,969 $ 262,605 0 100,000 100,000 $ (100,000) $ INPUTS & RISK ANALYSIS $ (3,000) 243,150 NET WORKING CAPITAL CASH FLOWS 0 2 $ $ 126,000 $ 113,400 $ 10.0% 18.0% 22,680 113,400 $ 90,720 $ 12,600 1 100,000 $ 3,000 103,000 (3,000) $ 103,000 3,090 106,090 F $ 3 (3,090) $ $ G 90,720 $ 14.4% 4 4 3,183 109,273 (3,183) $ $ 72,576 $ 11.5% 14,515 18,144 72,576 $ 58,061 $ Salvage Valu $ Gain (Loss) from Sale $ Tax $ $ After-tax Cash Flow $ $ 3 4 106,090 $ 109,273 $ 3,278 112,551 (3,278) $ H 5 300,361 112,551 273,026 685,938 5 58,061 9.2% 11,617 46,444 385,000 338,556 84,639 300,361 300,361 5 112,551 (112,551) 112,551 OPERATING CASH FLOWS 1 2 3 4 5 $ 1,500,000 $ 1,545,000 $1,591,350 $ 1,639,091 $1,688,263 1,215,400 1,251,862 1,289,418 1,328,100 1,180,000 12,600 22,680 18,144 14,515 11,617 307,400 306,920 321,344 335,157 348,546 76,850 76,730 80,336 83,789 87,136 230,550 230,190 241,008 251,368 261,409 12,600 22,680 18,144 14,515 11,617 $ 243,150 $ 252,870 $ 259,152 $ 265,883 $ 273,026 CASH FLOW DETERMINATION MACRS Depreciatic
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
When and why are quality (issues) in the news? Share a link to an article or news story, summarize the key points and define how the quality issue should be addressed.
-
(20 points)Write a program that prompts the user to input five decimal numbers. The program should then add the five decimal numbers, convert the sum to the nearest integer, and print the result....
-
Determine the transfer function from U(s) to Y(s) for the following block diagram. Provided are some recommended steps to take: a. Label each signal (line with arrow) b. Write the equation for each...
-
Calculate the moment of inertia about the base of composite lamina made up of a semicircle of 120 mm base diameter is removed from base of rectangle 120 mm X 500 mm such that lamina is symmetrical to...
-
Using the sample of retirement funds stored in a. Construct a table that tallies market cap, risk, and rating. b. What conclusions can you reach concerning differences among the types of funds based...
-
Use odds ratios in Table 8.3 to illustrate the collapsibility conditions. a. For (A, C, M), all conditional odds ratios equal 1.0. Explain why all reported marginal odds ratios equal 1.0. b. For (AC,...
-
What objective should guide the selection of a depreciation method for financial reporting purposes?(Appendix)
-
As part of a larger systems project, Clone Bank of Clone, Colorado, wants your help in setting up a new monthly reporting form for its checking and savings account customers. The president and vice...
-
MCV4U1 - UNIT 2 - DERIVATIVES TEST ROUND ALL ANSWERS TO THE NEAREST TENTH, UNLESS OTHERWISE STATED. 1) Differentiate each of the following functions. Final answers should not contain negative or...
-
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales for Item Zeta9 are as follows: Oct. 1 Inventory 58 units @ $16 7 Sale 43 units 15 Purchase 64 units @ $18 24 Sale 21 units...
-
Walmart uses the common low-active price strategy company. They use this approach to focus on offering everyday low prices. The main advantage of this strategy is that it is simple for the company...
-
Freeman company disposed of old furniture that had no value. Original cost $ 1 , 5 0 0 , accumulated deprecation, $ 1 , 3 0 0 . Make journal entry.
-
The campus bookstore has estimated that its profit (in dollars) from selling x hundred basketball conference championship t-shirts is given by the equation shown below. P = -47x+582x-523 The demand...
-
Universal Forest s current stock price is $ 6 3 . 0 0 and it is likely to pay a $ 0 . 6 7 dividend next year. Since analysts estimate Universal Forest will have a growth rate of 8 . 4 percent, what...
-
Describe the history, current status, and adoption implications of a Financial Accounting Standards Board ongoing project. Requirements The FASB has several ongoing projects that involve the review...
-
Question 2 1 pts Justine is the manager of an investment center. Currently Justine has an ROI of 20%, which is well above the company's average of 15%. The company desires an ROI of new projects to...
-
Answer the following two independent questions. a. MM Corporation is considering several proposed investments for the coming budget year. MM produces electrical apparatus for industrial complexes....
-
Swanson, Sáez, Gerber, and Leafstedt (2004) investigated cognitive functioning among bilingual children. The matrix shown below displays correlations among some of their cognitive...
-
1. Berta samples the IQ scores of 100 third graders. She calculates the standard deviation and obtains a result of 14.5. Based on this result, we can say with certainty that a. The sample included...
-
Which of the following would be considered hypothetical populations? a. Persons who received a flu shot at a local hospital last October b. Married couples who will still be married to each other in...
-
Computing unit cost for department and for completed units} with beginning inventory Robert E. Lee Company has two production departments. Blending had 1,000 units in process at the beginning of the...
-
Identifying cost flows in process cost system} List in columnar form the transactions and the accounts debited and credited to reflect the flow of costs through a process cost accounting system for...
-
Departmental cost work sheet analysis; cost of production} summary, three departments, no beginning inventories Goode Manufacturing Co. has three departments and uses the process cost system of...
Study smarter with the SolutionInn App