Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please show how you got your answer. im still a little new to excel. If you do both questions i would be forever grateful and
please show how you got your answer. im still a little new to excel. If you do both questions i would be forever grateful and make sure you get at least three thumbs up:)
B D E F G H I 6 Catzz Corp is considering making and selling Trolls' themed cat sweaters. 7 Catzz expects to sell the sweaters for $35 each; this project is expected to last three years due to changes in popular movies. 8 Catz will need to buy equipment costing $100,000; this equipment will use the new 2018 tax laws so will have bonus depreciation year 1. 9 Variable costs are expected to be $20 each sweater; this includes both material costs and licensing fees to Dreamworks. 10 Fixed costs are expected to be $55,000 a year which includes advertising and management costs. 11 Catzz expects to sell 4,000 sweaters in the first year, 6,000 and 8000 sweaters the third year. 12 At the end of the third year, Catzz will end the project and believes it can sell the machine for $40,000 despite the machine's zero book value (due to 2018 tax laws). 13 Net working capital needs are $10,000 in year 0 and 10% of revenues in years 1-3. Net working capital will be liquidated in year 3. 14 Catzz has a marginal tax rate of 21% and this project has a required rate of 12% due to its high risk. (Assume Catzz is a very profitable company which can take tax credits when EBIT is less than zero.) 15 Assume Catzz is a very profitable company which can take tax credits when EBIT is less than zero. 16 Information from above in table form: 17 Cost of equipment year 0 $ 100,000 installed 18 Bonus depreciation on equipment 19 Expect to sell equipment for $ 40,000 in year 3 20 Year year 1 year 2 21 Quantity sold per year 0 4000 6000 8000 22 Price $ 35.00 per sweater 23 Variable costs $20.00 per sweater 24 Fixed costs $ 55,000.00 per year 25 Net working capital year 0 10000 year o 26 Net working years 1-3 10% of revenues 27 Net working capital will be liquidated in year 3 28 Catzz marginal tax rate 21% 29 Required rate on project 12% year 3 B D E 1 2 3 49 5. Set up the Net Working Capital Cash Flows for years 0-3: 50 Year 0 51 Revenue 52 Initial net working capital requirement 53 Net Working capital needs 54 Liquidation of net working capital 55 Cash flow net working capital* 56 6. Set up the free cash flows of the project 57 Year 0 58 Operating Cash Flow 59 Net Working capital cash flow* 60 Capital Spending cash flow* 61 Free Cash Flow 62 7. a. What is the Net Present Value of the Troll themed cat sweater project? 1 2 3 B D E F G H I 6 Catzz Corp is considering making and selling Trolls' themed cat sweaters. 7 Catzz expects to sell the sweaters for $35 each; this project is expected to last three years due to changes in popular movies. 8 Catz will need to buy equipment costing $100,000; this equipment will use the new 2018 tax laws so will have bonus depreciation year 1. 9 Variable costs are expected to be $20 each sweater; this includes both material costs and licensing fees to Dreamworks. 10 Fixed costs are expected to be $55,000 a year which includes advertising and management costs. 11 Catzz expects to sell 4,000 sweaters in the first year, 6,000 and 8000 sweaters the third year. 12 At the end of the third year, Catzz will end the project and believes it can sell the machine for $40,000 despite the machine's zero book value (due to 2018 tax laws). 13 Net working capital needs are $10,000 in year 0 and 10% of revenues in years 1-3. Net working capital will be liquidated in year 3. 14 Catzz has a marginal tax rate of 21% and this project has a required rate of 12% due to its high risk. (Assume Catzz is a very profitable company which can take tax credits when EBIT is less than zero.) 15 Assume Catzz is a very profitable company which can take tax credits when EBIT is less than zero. 16 Information from above in table form: 17 Cost of equipment year 0 $ 100,000 installed 18 Bonus depreciation on equipment 19 Expect to sell equipment for $ 40,000 in year 3 20 Year year 1 year 2 21 Quantity sold per year 0 4000 6000 8000 22 Price $ 35.00 per sweater 23 Variable costs $20.00 per sweater 24 Fixed costs $ 55,000.00 per year 25 Net working capital year 0 10000 year o 26 Net working years 1-3 10% of revenues 27 Net working capital will be liquidated in year 3 28 Catzz marginal tax rate 21% 29 Required rate on project 12% year 3 B D E 1 2 3 49 5. Set up the Net Working Capital Cash Flows for years 0-3: 50 Year 0 51 Revenue 52 Initial net working capital requirement 53 Net Working capital needs 54 Liquidation of net working capital 55 Cash flow net working capital* 56 6. Set up the free cash flows of the project 57 Year 0 58 Operating Cash Flow 59 Net Working capital cash flow* 60 Capital Spending cash flow* 61 Free Cash Flow 62 7. a. What is the Net Present Value of the Troll themed cat sweater project? 1 2 3Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started