Please help!!

NPV. Miglietti Restaurants is looking at a project with the following forecasted sales: first-year sales quantity of 35,000, with an annual growth rate of 4.00% over the next ten years. The sales price per unit will start at $45.00 and will grow at 2.00% per year. The production costs are expected to be 55% of the current year's sales price. The manufacturing equipment to aid this project will have a total cost (including installation) of $2,100,000. It will be depreciated using MACRS, and has a seven-year MACRS life classification. Fixed costs will be $340,000 per year. Miglietti Restaurants has a tax rate of 40%. What is the operating cash flow for this project over these ten years? Find the NPV of the project for Miglietti Restaurants if the manufacturing equipment can be sold for $150,000 at the end of the ten-year project and the cost of capital for this project is 7%.

AutoSave Off HO data-11_5_2021-4_26 PM - Excel O Search kendarious toles KT IT File Home Insert Page Layout Formulas Data Review View Help Share Comments NT TT Calibri 11 - AP = = = ab Wrap Text General A M Y W @ IN Analyze Data Paste MA A + $ %) 08 Merge & Center Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Analysis A1 X for Year B D F G H I J K K L M M N O P R S S T U A A Year 1 2 3 3-Year 133.33% 244.45% 314.81% 41 7.41% 5 5 4 5-Year 20.00% 32.00% 19.20% 11.52% 11.52% 5.76% 5 7-Year 14.29% 24.49% 17.49% 12.49% 8.93% 8.93% 8.93% 4.45% 6 E E 10-Year 10.00% 18.00% 14.40% 11.52% 9.22% 7.37% 6.55% 6.55% 6.55% 6.55% 3.28% 7 6 7 8 9 8 8 10 9 11 10 12 11 13 14 15 16 17 18 19 20 21 22 Ready 6 + 100% Type here to search j o . 60F 3:30 PM 11/5/2021