In: Finance
You have decided to get into the cotton candy business. A new cotton candy machine will cost $3260 plus $400 shipping. You will have to pay an electrician $60 to hook it up. Initial inventory expenses will be $600.
You expect the machine to return revenues of $3000 each year. Operating expenses should be $750 annually. You will have to purchase a new sugar basket (cost $100) every year after the first year. You expect the to use the machine for three years then sale it for $1000. The machine is depreciated over four years using the straight line depreciation method. Your tax rate is 40% and the company's required return on investment is 10%
If you have a negative Capital Gain then The tax will be negative, that is a deduction) it will be added to the salvage instead of subtracted.
Compute the initial outlay in year Zero ["$4,320", "$5,210", "$4,680"]
Compute Cash Flows for Year One. ["$1,428", "$1722", "$1,528"]
Compute the non-operating cash flows ["$1722", "$1,572", "$1,528"]
Compute the cash flows for year three (OPERATIONAL AND NON OPERATIONAL). ["$2,972", "$3,528", "$3,234"]
Compute the NPV. (You're gonna need year 2 for this) ["$1,528", "$1,048", "-$632"]
Investment in Cotton Candy Machine | |
Cost of Machine | 3,260 |
Add : Shipping cost | 400 |
Add: Payment to electrician | 60 |
Total Machine cost Capitalized | 3,720 |
Useful life in years | 4 |
Annual SL depreciation | 930.00 |
Tax Rate | 40% |
Annual Depreciation Tax saving=930*40%= | 372 |
Accumulated depreciation in 3 years | 2,790 |
Written down value after year 3 | 930 |
Sale value after 3 years | 1,000 |
Capital gain on sale | 70 |
Tax on Capital gains =70*40%= | 28 |
After Tax salvage value =1000-28= | 972 |
NPV calculation | Year 0 | Year 1 | Year 2 | Year 3 | |
Initial Investment | |||||
Cost of Machine | (3,720) | ||||
Investment in NWC | (600) | ||||
a | Total Initial Investment | (4,320) | |||
Operating cash flow | |||||
Annual Revenue | 3,000 | 3,000 | 3,000 | ||
Annual Operating expense | 750 | 750 | 750 | ||
Annual Cost of Sugar basket | - | 100 | 100 | ||
Before Tax income (w/o depreciation) | - | 2,250 | 2,150 | 2,150 | |
Tax @40% | - | 900 | 860 | 860 | |
Annual After Tax income | - | 1,350 | 1,290 | 1,290 | |
Add Annual Depreciation Tax saving | 372 | 372 | 372 | ||
b | Total Operating Cash flow Year 1 | 1,722 | 1,662 | 1,662 | |
c | Terminal Cash flow | ||||
Salvage value after Tax | 972 | ||||
Return of NWC | 600 | ||||
d | Total Terminal Non operating cash flow | 1,572 | |||
e | Total Free Cash flow from Project=a+b+c | (4,320) | 1,722 | 1,662 | 3,234 |
f | PV factor @10% =1/1.1^n | 1 | 0.9091 | 0.8264 | 0.7513 |
g | PV of FCF =e*f= | (4,320.00) | 1,565.45 | 1,373.55 | 2,429.75 |
h | NPV =Sum of PV of FCF | 1,048 |
Initial Outlay in Year Zero = | $ (4,320.00) |
Cash flow for year 1 | $ 1,722.00 |
Non operating cash flow | $ 1,572.00 |
Total Cash flow for year 3 | $ 3,234.00 |
Project NPV = | $ 1,048 |