Please show work on Excel :)

Wrap Test Generl Copy Format Panter Formatting Table Styles F Select After graduating with a marketing degree, you have decided that your best career is not as Assistant Manager at Old Navy. Inste you decide to sta 3 rt your own small business plowing snow. You will need to buy a used Ford F350 truck and have found one at a i F ord dealer for S45.000. You will have to borrow to buy the truck at an interest rate of 10% applicable to the whole purchase price local 4 The truck should last for 10 years and will be depreciated to $5,000. The used snow plow you found on Craig's tist will 5 be depreciated to $O over 10 years 7 Go ing rates for snow plowing residential driveways in Lincolnwood is $30 per snowfall. Snow is expected to fall in the area 10 times 8 per winter. You estimate you can plow the following number of driveways: 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 1 200 220 250 300 350 350 350 350 350 350 13 : Your cost of goods as a percent of revenus is estimated constanly at 55%. Your S,G&A as a percent of revenues is estimate at 22%, 14 The corporate tax rate applicable to your company is 33%. Assume an opportunity cost of capital of 11 15 O 1. Document all assumptions in an organized way. (10 points) 1-30 0 3-40 4-30 5 50 Fermulan Data Rviw V w Acrobat Tel me whut you want to do. Insert Page Layout Calbn hert Delete Fermat a Cepy Format P.rte, 53 Merge&Center Formatting TableShyles Pante A31 16 1. Document all assumptions in an organized way. 17 18 2. Highlight all your projected Net Income Valu projected Net Income Values.(10 points) 19 20 3 a. Calculate the NPV of the project. (20 points) 21 22 4. Calculate the IRR of the project. (10 points) 23 24 25 26 27 28 1-30 2-50 3-40 430