Data table HomeNet's Net Working Capital Requirements Net Working Capital Forecast ($000s) 1 Cash Requirements 2...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Data table HomeNet's Net Working Capital Requirements Net Working Capital Forecast ($000s) 1 Cash Requirements 2 Inventory 3 Receivables (15% of sales) 4 Payable (15% of COGS) 5 Net Working Capital Year 0 1 2 3 4 5 3,525 (1,425) 2,100 3,525 3,525 3,525- (1,425) (1.425) (1,425) - 2,100 2,100 2,100 - (Click on the following icon in order to copy its contents into a spreadsheet.) Calculation of Home Net's Free Cash Flow Year 0 1 2 3 4 5 Incremental Earnings Forecast ($000s) 1 Sales 2 Cost of Goods Sold 23,500 (9,500) (9,500) 23,500 23,500 23,500 3 Gross Profits 14,000 (9,500) (9,500) 14,000 14,000 14,000 4 Selling, General, and Administrative (3,000) (3,000) (3,000) (3,000) 5 Research and Development (15,000) 6 Depreciation (1,500) (1,500) (1,500) (1,500) (1,500) 7 EBIT (15,000) 9,500 9,500 9,500 9,500 (1,500) 8 Income Tax at 20% 3,000 (1,900) (1,900) (1,900) (1,900) 300 9 Unlevered Net Income (12,000) 7,600 7,600 7,600 7,600 (1,200) Free Cash Flow ($000s) 10 Plus: Depreciation 1,500 1,500 1,500 1,500 1,500 11 Less: Capital Expenditures (7,500) 12 Less: Increases in NWC (2,100) 2,100 13 Free Cash Flow (19,500) 7,000 9,100 9,100 9,100 2,400 Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year 0 1 2 3 4 5 HomeNet Units Sales (000s) 54 Sales Price ($/unit) 10% Cost of Goods Sold (S/unit) 20% 50 104 158 212 260 234.00 210.60 189.54 120 96.00 76.80 61.44 Operating Expenses ($000s) Hardware & Software Develop. (15,000) Marketing & Technical Support (2,800) (2,800) (2,800) (2,800) Capital Expenditures Lab Equipment (7,500) Depreciation 100% Corporate Tax Rate 20% 20% 20% 20% 20% (Click on the following icon in order to copy its contents into a spreadsheet.) Incremental Earnings Forecast ($000s) Year 0 1 2 3 4 5 1 Sales 2 Cost of Goods Sold 3 Gross Profits 4 Selling, General, and Administrative 13,000 24,336 33,275 40,182 (6,000) (9,984) (12,134) (13,025) 7,000 14,352 21,141 27,157 (2,800) (2,800) (2,800) (2,800) 5 Research and Development (15,000) 6 Depreciation (7,500) 7 EBIT (22,500) 4,200 11,552 18,341 24,357 8 Income Tax at 20% 4,500 (840) (2,310) (3,668) (4,871) 9 Unlevered Net Income (18,000) 3,360 9,242 14,673 19,486 a. Calculate HomeNet's net working capital requirements (that is, reproduce Table 8.4 under the assumptions given). The net working capital for year 1 is $4,05 (Round to the nearest thousand dollars.) The net working capital for year 2 is $2,150. (Round to the nearest thousand dollars.) The net working capital for year 3 is $5,176. (Round to the nearest thousand dollars.) The net working capital for year 4 is $ (Round to the nearest thousand dollars.) The net working capital for year 5 is $ (Round to the nearest thousand dollar.) b. Calculate Home Net's FCF (that is, reproduce Table 8.3 under the same assumptions). The free cash flow for year 0 is $18,000. (Round to the nearest thousand dollars.) The free cash flow for year 1 is $ 2,516. (Round to the nearest thousand dollars.) The free cash flow for year 2 is $8,130 (Round to the nearest thousand dollars.) The free cash flow for year 3 is $ 19,671. (Round to the nearest thousand dollars.) The free cash flow for year 4 is $10,649 (Round to the nearest thousand dollars.) The free cash flow for year 5 is $4,007. (Round to the nearest thousand dollars.) Data table HomeNet's Net Working Capital Requirements Net Working Capital Forecast ($000s) 1 Cash Requirements 2 Inventory 3 Receivables (15% of sales) 4 Payable (15% of COGS) 5 Net Working Capital Year 0 1 2 3 4 5 3,525 (1,425) 2,100 3,525 3,525 3,525- (1,425) (1.425) (1,425) - 2,100 2,100 2,100 - (Click on the following icon in order to copy its contents into a spreadsheet.) Calculation of Home Net's Free Cash Flow Year 0 1 2 3 4 5 Incremental Earnings Forecast ($000s) 1 Sales 2 Cost of Goods Sold 23,500 (9,500) (9,500) 23,500 23,500 23,500 3 Gross Profits 14,000 (9,500) (9,500) 14,000 14,000 14,000 4 Selling, General, and Administrative (3,000) (3,000) (3,000) (3,000) 5 Research and Development (15,000) 6 Depreciation (1,500) (1,500) (1,500) (1,500) (1,500) 7 EBIT (15,000) 9,500 9,500 9,500 9,500 (1,500) 8 Income Tax at 20% 3,000 (1,900) (1,900) (1,900) (1,900) 300 9 Unlevered Net Income (12,000) 7,600 7,600 7,600 7,600 (1,200) Free Cash Flow ($000s) 10 Plus: Depreciation 1,500 1,500 1,500 1,500 1,500 11 Less: Capital Expenditures (7,500) 12 Less: Increases in NWC (2,100) 2,100 13 Free Cash Flow (19,500) 7,000 9,100 9,100 9,100 2,400 Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year 0 1 2 3 4 5 HomeNet Units Sales (000s) 54 Sales Price ($/unit) 10% Cost of Goods Sold (S/unit) 20% 50 104 158 212 260 234.00 210.60 189.54 120 96.00 76.80 61.44 Operating Expenses ($000s) Hardware & Software Develop. (15,000) Marketing & Technical Support (2,800) (2,800) (2,800) (2,800) Capital Expenditures Lab Equipment (7,500) Depreciation 100% Corporate Tax Rate 20% 20% 20% 20% 20% (Click on the following icon in order to copy its contents into a spreadsheet.) Incremental Earnings Forecast ($000s) Year 0 1 2 3 4 5 1 Sales 2 Cost of Goods Sold 3 Gross Profits 4 Selling, General, and Administrative 13,000 24,336 33,275 40,182 (6,000) (9,984) (12,134) (13,025) 7,000 14,352 21,141 27,157 (2,800) (2,800) (2,800) (2,800) 5 Research and Development (15,000) 6 Depreciation (7,500) 7 EBIT (22,500) 4,200 11,552 18,341 24,357 8 Income Tax at 20% 4,500 (840) (2,310) (3,668) (4,871) 9 Unlevered Net Income (18,000) 3,360 9,242 14,673 19,486 a. Calculate HomeNet's net working capital requirements (that is, reproduce Table 8.4 under the assumptions given). The net working capital for year 1 is $4,05 (Round to the nearest thousand dollars.) The net working capital for year 2 is $2,150. (Round to the nearest thousand dollars.) The net working capital for year 3 is $5,176. (Round to the nearest thousand dollars.) The net working capital for year 4 is $ (Round to the nearest thousand dollars.) The net working capital for year 5 is $ (Round to the nearest thousand dollar.) b. Calculate Home Net's FCF (that is, reproduce Table 8.3 under the same assumptions). The free cash flow for year 0 is $18,000. (Round to the nearest thousand dollars.) The free cash flow for year 1 is $ 2,516. (Round to the nearest thousand dollars.) The free cash flow for year 2 is $8,130 (Round to the nearest thousand dollars.) The free cash flow for year 3 is $ 19,671. (Round to the nearest thousand dollars.) The free cash flow for year 4 is $10,649 (Round to the nearest thousand dollars.) The free cash flow for year 5 is $4,007. (Round to the nearest thousand dollars.)
Expert Answer:
Related Book For
Linear Algebra And Its Applications
ISBN: 9781292351216
6th Global Edition
Authors: David Lay, Steven Lay, Judi McDonald
Posted Date:
Students also viewed these finance questions
-
People usually experience social life through which of the following? a. Cultural values Ob. Multiple identities O&A single identity O d. Religious values
-
Calculate the marginal propensity to save. You are given the following information about the economy of Australia: Saving (billions of dollars per year) Disposable income 0 100 200 300 400 0 25 50 75...
-
Suppose that HomeNet will have no incremental cash or inventory requirements (products will be shipped directly from the contract manufacturer to customers). However, receivables related to HomeNet...
-
Solve exponential equation. Express irrational solutions in exact form and as a decimal rounded to three decimal places. 2 2x + 2 x - 12 = 0
-
A portion of the combined statement of income and retained earnings of Nestor Inc. for the current year ended December 31, 2014 follows: Note 1. During the year, Nestor Inc. suffered a loss from...
-
For any function y = (x), the following hold true. (a) The real solutions of (x) = 0 correspond to the x-intercepts of the graph. (b) The real solutions of (x) < 0 are the x-values for which the...
-
Estimate the overall odds ratio of the set of tables in Problem3.6 and test whether the odds ratios are the same across the tables. Problem3.6 is: 3.6 Use the DOS data to test whether there is gender...
-
The following questions concern the determination of the proper sample size in audit sampling using the following table: Required a. Assume that the initial sample size for column 1 using...
-
Video - Youtube -Lease Accounting Basic Example To Determine Lease Type (Capital Vs Operating Lease) https://www.youtube.com/watch?v=slNrpKODlSw
-
Pick three countries identified as emerging markets. The countries currently listed as emerging markets are: Brazil, Chile, Columbia, The Czech Republic, Greece, Hungary, India, Indonesia, Malaysia,...
-
If you could blame just one person or group of people who caused the Great Depression, which one of the following would you choose? a) President Herbert Hoover b) President Franklin Roosevelt c) the...
-
The year 2012 could be described as having had a relatively____ unemployment rate and a relatively _____rate of inflation. a) low, low c) high, low b) high, high d) low, high
-
________. completely changed the face of the United States in the 25 years following World War II. a) Almost constant warfare b) Suburbanization c) Welfare spending d) The loss of jobs to Japan,...
-
Which statement is the most accurate? a) The 21st century will almost definitely be another American Century. b) The 21st century, rather than the 20th, will be called The American Century. c) The...
-
Our most rapid job growth was in the period from _____. a) 2000 to 2005 b) 1995 to 2000 c) 1978 to 1983 d) 1953 to 1958
-
"Expenses are assets that have been? used." Explain.
-
Citing a scientific article, explain in your own words, how DNA fingerprinting has been used in forensic science to solve crimes and why it may not always be accurate or effective.
-
Show how the axioms for a vector space V can be used to prove the elementary properties described after the definition of a vector space. Fill in the blanks with the appropriate axiom numbers....
-
Determine the values of the parameter s for which the system has a unique solution, and describe the solution. 38x1 + 5x2 = 3 12x + 5sx = 2
-
Find an example to show that the convexity of S is necessary in Exercise 25. Data From Exercise 25 If c R and S is a set, define cS = {cx : x S}. Let S be a convex set and suppose c > 0 and d > 0....
-
Decide whether the system in Problem 4 is stable. A linear dynamic system is stable if the homogeneous solution of its mathematical model, subjected to the prescribed initial conditions, decays. More...
-
Perform the indicated operations, if defined, for the following vectors and matrices. \(\left(\mathbf{B}-\mathbf{v} \mathbf{w}^{T} ight) \mathbf{A}\) -2 1 -3 1 1 A = 1 -3 2 1 32 B = V= W = 0 0 4 5
-
Perform the indicated operations, if defined, for the following vectors and matrices. \(\left(\mathbf{A B}^{T} ight) \mathbf{v}\) -2 1 -3 1 1 A = 1 -3 2 1 32 B = V= W = 0 0 4 5
Study smarter with the SolutionInn App