I know I should get the following information, but cannot figure it out in excel. Please provide formulas for cells if possible.

Contribution Margin: $ 58,150 Depreciation Expense in Year 2: $ 23,360 Year 8 Undiscounted After-Tax Cash Flows: $ 17,170 NPV: (13,231) IRR: 3.09%

Fancy's Food Truck ACCT 333 Excel #6 Mr. Milbert Fancy has a desire to open and operate a food truck. He is exploring whether such an endeavor would be profitable. Because you did so well helping Uncle Murray with his financial statements, your mother has referred Mr. Fancy to you. He plans to operate the food truck for eight years. At the end of the eighth year Mr. Fancy will sell off his equipment, and start a flamingo farm in Florida. After careful study Mr. Milbert Fancy has determined that he can purchase a vehicle for $70,000. Eddie, the owner of the shop that will outfit the truck has told Milbert Fancy that it will cost around $3,000 to prepare t specifications. Eddie also told him that the truck should be worth around $15,000 in eight years. ruck to Fancy's he t Furthermore, an investment of an additional $2,000 would be required to purchase cleaning supplies, ingredients, and so forth. After eight years, half of the working capital would be returned to Mr. Fancy Milbert wl need rent space in a DHEC approved prep-kitchen. This will cost 1.5% of sales. He expects each year. Maintenance will be $5,000 per year. Milbert expects to drive 12,000 miles each year. The truck's consumption of fuel is 3.0 miles-per-gallon, and Milbert predicts that the average cost of fuel will be $4.26 per gallon. He also expects to operate his truck five days each week. He wants to have some time off to visit the beach each summer, so he will run the truck for fifty weeks each year him $10,082 per year plus expects insurance will be S12,000 to incur $4.500 of cleaning costs per year, and After reviewing the cost of recipes that students in this class conducted, Milbert has selected one for his main dish that should prove popular on his food truck route. By adjusting proportions, he has gotten the cost down to $2.43 per serving. As an additional source of revenue, he will also offer a second item that will cost him 95 per serving. Milbert wishes to have a 45% gross margin on all sales, but wants his selling price to in whole dollars (use the "round" function). He expects to sell 100 servings of the main dish each day, and expects that the second item's sales will be 80% of the main dish's volume. The income tax rate is 30% and is expected to remain at that level for the full five years. The IRS classifies the food truck as being in the 5-year property class, and the capital equipment will be depreciated using the IRS modified accelerated cost recovery system (MACRS). The MACRS tables are found below for the calculation of annual depreciation expense. Required: Construct in Excel a schedule of discounted annual cash flows associated for the proposed venture. (Use a format similar to that found in Exhibit 13-7 and the Review Problem from our textbook.) Use Excel to calculate the following: a) The net present value of the investment using an interest rate of 10%. b) The Internal Rate of Return for the venture. This assigument is worth 20 points. It must be submitted on time through Blackboard. Assistance disclosure must be made. ear MACRS Pro 3-Year Class 33.33% 44.45% 14.81% 7.41% 5-Year Class 20.00% 32.00% 19.20% 11 ,52% 11 ,5296 576% 7-Year Class 14.29% 24.49% 17.49% 12.49% 10-Year Class 10.00% 18.00% 14.40% I 1.5296 9.22% 7 37% 3 6 8.92% 4.46% 6.55%