Need assistance (New Heritage Doll Company) determining Net Working Capital, NPV, and IRR for year 2010-2020. The
Fantastic news! We've Found the answer you've been seeking!
Question:
Need assistance (New Heritage Doll Company) determining Net Working Capital, NPV, and IRR for year 2010-2020. The tax Rate is 40%.Include formulas and solutions. Began NWC in 2011, but am stuck.
Transcribed Image Text:
H67 1 2 3 4 Revenue 5 X ✓ fx Calc Here Revenue Growth A 6 Production Costs 7 Fixed Production Expense (exic. Depreciation) 8 Variable Production Costs 9 Depreciation 10 Total Production Costs 11 Selling, General, & Administrative 12 Total Operating Expense 13 14 Operating Profit 15 Operating Profit/Sales 16 SG&A/Sales 17 18 Working Capital Assumptions: 19 Minimum Cash Balance as % of Sales 20 Days Sales Outstanding 21 Inventory Turnover (prod. Cost/ending inv.) 22 Days Payable Outstanding (based on tot. op. exp.) 22 23 24 Capital Expenditure Growth in Capex 25 26 B с D E F G Selected Operating Projections for Design Your Own Doll ($ in thousands) ▼ ▼ ▼ ▼ 2010 ($1,250) ΝΑ NA ΝΑ ΝΑ 575 2,035 152 2,762 1,250 1,155 $1,250 $3,917 2011 $4,500 $1,470 NA ΝΑ NA ΝΑ $583 0.130 0.257 2012 $6,860 52.4% 575 3,404 587 4,291 152 152 4,131 5,030 1,735 2,102 $5,866 $7,132 2013 $8,409 22.6% $994 $1,277 0.145 0.152 0.253 0.250 3.0% 59.2x 12.2x 33.7x $952 $152 -35.24% -84.03% 3.0% 59.2x 12.3x 33.8x 2014 $9,082 8.0% 598 4,669 152 5,419 2,270 $7,689 $1,393 0.153 0.250 3.0% 59.2x 12.6x 33.9x $152 $334 0.00% 119.74% H 2015 $9,808 8.0% 610 5,078 164 5,852 2,452 $8,304 $1,504 0.153 0.250 3.0% 59.2x 12.7x 33.9x $361 8.08% 1 2016 2017 $10,593 $11,440 8.0 % 8.0% 622 5,521 178 6,321 2,648 $8,969 J 3.0% 59.2x 12.7x 33.9x $389 7.76% K $1,624 $1,753 $1,892 0.153 0.153 0.153 0.250 0.250 0.250 3.0% 59.2x 12.7x 33.9x 2018 2019 2020 $12,355 $13,344 $14,411 8.0% 8.0% 8.0% 660 674 7,079 7,685 635 648 6,000 6,519 192 207 224 242 6,827 7,374 7,963 8,601 2,860 3,089 3,336 3,603 $9,687 $10,463 $11,299 $12,204 L 3.0% 59.2x 12.7x 33.9x $421 $454 8.23% 7.84% M $2,045 $2,207 0.153 0.250 3.0% 59.2x 12.7x 33.9x $491 8.15% 0.153 0.250 3.0% 59.2x 12.7x 33.9x $530 7.94% N 0 H67 1 2 3 4 Revenue 5 X ✓ fx Calc Here Revenue Growth A 6 Production Costs 7 Fixed Production Expense (exic. Depreciation) 8 Variable Production Costs 9 Depreciation 10 Total Production Costs 11 Selling, General, & Administrative 12 Total Operating Expense 13 14 Operating Profit 15 Operating Profit/Sales 16 SG&A/Sales 17 18 Working Capital Assumptions: 19 Minimum Cash Balance as % of Sales 20 Days Sales Outstanding 21 Inventory Turnover (prod. Cost/ending inv.) 22 Days Payable Outstanding (based on tot. op. exp.) 22 23 24 Capital Expenditure Growth in Capex 25 26 B с D E F G Selected Operating Projections for Design Your Own Doll ($ in thousands) ▼ ▼ ▼ ▼ 2010 ($1,250) ΝΑ NA ΝΑ ΝΑ 575 2,035 152 2,762 1,250 1,155 $1,250 $3,917 2011 $4,500 $1,470 NA ΝΑ NA ΝΑ $583 0.130 0.257 2012 $6,860 52.4% 575 3,404 587 4,291 152 152 4,131 5,030 1,735 2,102 $5,866 $7,132 2013 $8,409 22.6% $994 $1,277 0.145 0.152 0.253 0.250 3.0% 59.2x 12.2x 33.7x $952 $152 -35.24% -84.03% 3.0% 59.2x 12.3x 33.8x 2014 $9,082 8.0% 598 4,669 152 5,419 2,270 $7,689 $1,393 0.153 0.250 3.0% 59.2x 12.6x 33.9x $152 $334 0.00% 119.74% H 2015 $9,808 8.0% 610 5,078 164 5,852 2,452 $8,304 $1,504 0.153 0.250 3.0% 59.2x 12.7x 33.9x $361 8.08% 1 2016 2017 $10,593 $11,440 8.0 % 8.0% 622 5,521 178 6,321 2,648 $8,969 J 3.0% 59.2x 12.7x 33.9x $389 7.76% K $1,624 $1,753 $1,892 0.153 0.153 0.153 0.250 0.250 0.250 3.0% 59.2x 12.7x 33.9x 2018 2019 2020 $12,355 $13,344 $14,411 8.0% 8.0% 8.0% 660 674 7,079 7,685 635 648 6,000 6,519 192 207 224 242 6,827 7,374 7,963 8,601 2,860 3,089 3,336 3,603 $9,687 $10,463 $11,299 $12,204 L 3.0% 59.2x 12.7x 33.9x $421 $454 8.23% 7.84% M $2,045 $2,207 0.153 0.250 3.0% 59.2x 12.7x 33.9x $491 8.15% 0.153 0.250 3.0% 59.2x 12.7x 33.9x $530 7.94% N 0
Expert Answer:
Answer rating: 100% (QA)
NWC Cash Accounts Receivable Inventory Accounts Payable NWC 135 730 359 331 NWC 1043 ANWC NWC Capita... View the full answer
Related Book For
Posted Date:
Students also viewed these organizational behavior questions
-
In the New Heritage Doll Company Case, What are the key facts?
-
Calculate 20 year cash flows, NPV and IRR for a 500 MW gas fired electricity generating plant with the following characteristics. Capital Cost, per kilowatt $ 590.00 Generator Capability, MW 500...
-
Assume that the tax rate is 35 percent. You can borrow at 8 percent before taxes. Should you lease or buy? You work for a nuclear research laboratory that is contemplating leasing a diagnostic...
-
Payroll Assignment - (50 Marks) The following employees are working in the ABC Clinic, they are paid biweekly. Calculate the gross income, net income, and the total remittance that ABC is to report...
-
The company controller, Barry Melrose, has asked for your help in interpreting the authoritative accounting literature that addresses the recognition and measurement of impairment losses for...
-
The following information is available for Mint Corporation: Common Stock ($10 par)............................................................. $1,500,000 Paid-in Capital in Excess of Par -...
-
Why a temporary restraining order or preliminary injunction may be necessary?
-
A closed curve encircles several conductors. The line integral ф B.d1 around this curve is 3.83 X l0-4 T.m. (a) What is the net current in the conductors? (b) If you were to integrate around...
-
a), What is the throughput of this process for the whole year? b). What is the customer service level that you can meet (or what percentage of demand can you meet) c). What is the bottleneck for this...
-
A beam of T section is supported and loaded as shown. a) (15 pts) Construct the shear and bending moment diagram, provide expressions for the shear and bending moment on each segment, provide graphs,...
-
Stuckies produces white school glue. Their glue bottles are primarily sold at department stores across the country. The cost of manufacturing and marketing their glue, at their normal factory volume...
-
Bassett Corporation has two production departments, Milling and Customizing. The company uses a job-order costing system and computes a predetermined overhead rate in each production department. The...
-
Liquor Licencing law Liang works for The Event Co., who are a part of The Experience Co-operative. The Event. Co. runs themed market events offering entertainment, food and bars in an outdoor...
-
What are some known mitochondrial disorders that result from defects in the electron transport chain, and what are the cellular consequences of these defects ?
-
The diameter of a hydrogen atom is approximately 1 . 0 6 1 0 1 0 m , as defined by the diameter of the spherical electron cloud around the nucleus. The hydrogen nucleus has a diameter of...
-
Discuss the role of the Krebs cycle (also known as the citric acid cycle) in both energy production and as an anaplerotic source of precursors for other biosynthetic pathways .
-
Monetary Policy and Money Markets a. Graph the demand and supply of money at equilibrium. Identify the area of excess supply of money and excess demand for money. b.Graph the impact of contractionary...
-
An Atomic Energy Commission nuclear facility was established in Hanford, Washington, in 1943. Over the years, a significant amount of strontium 90 and cesium 137 leaked into the Columbia River. In a...
-
Dereks Donuts is considering two mutually exclusive investments. The projects expected net cash flows are as follows: a. Construct NPV profiles for Projects A and B. b. What is each projects IRR? c....
-
A father is planning a savings program to put his daughter through college. His daughter is now 13 years old. She plans to enroll at the university in five years, and it should take her four years to...
-
Following is information for three mutually exclusive capital budgeting projects that the CFO of Universal Fire Systems (UFS) is currently evaluating: a. Which project(s) should be purchased...
-
Simulation is helpful in learning vector time series. Define the matrices Use the command to generate 300 observations from the VAR(1) model \[ z_{t}=C z_{t-1}+a_{t} \] where \(a_{t}\) are iid...
-
Use the matrices of Problem 1 and the following command to generate 200 observations from the VMA(1) model, \(\boldsymbol{z}_{t}=\boldsymbol{a}_{t}-\boldsymbol{C} \boldsymbol{a}_{t-1}\), where...
-
The file \(q\)-fdebt.txt contains the U.S. quarterly federal debts held by (a) foreign and international investors, (b) federal reserve banks, and (c) the public. The data are from the Federal...
Study smarter with the SolutionInn App