updated question with white backround is below the original thank u!

probilam Mangensent of lee Cold is ceatemplating the purphese of a nce ice cream trukk. The corppany plans to eutablish new rostes for cach of the tracks near the beaches in Southern California where the weather is pleakand year-rouad. Coskilerable reiemenh bas been performed en estimated demand in consideration of expected larper demand during the sumaner and wcekends. The cath flows of the vas models differ dae bs be freercr capocity and custiener. windows. specifications. The coatpany's minimum required mate of retans is 10%. Details of the purchace price of the vans is givea belser: Iastractiens? There are multiple parts is this problem. Lse liscel is perform the fothowing:- PART 15 Complete the table as rudtined in the morksheet tomanary All requircments are [istid as letters A through J ca that wuckibect. The table must be compated wing Eicel formalax; me menters are to be catered? PART 2a loe Cold eximates that it will tale veveral start-e years before the full reverect are achieved. It wath to calcelate fovesest bo loc ased for NPVIRRR analysis uking the following startup pencentar as. Years 3. 5 10x2= 104 ise 1 Calculate the NIV and IRR foe the foer madel. The learplate is ca the "Cash flows" worksheet. It Calcalate the pay back for the 4 madels. C. Cell refercmec your revults (NPV, IRRE Paghach) to the "reselts" teble in your "sunmary" workshect. PART 3: Creale a pisch tuble. The rows shoeld be the different sep was movele. Theee shotid be 5 colurnan * Initial imvetment Payback Income afler tax IRR sertinges is format the bortoen line as an averege. Management of lee Cold is contemplating the purchase of a nes ice cream truck. The company plans to establish Bew routes for each of the trucks near the bcaches in Southern Califorsia Where the weather is pleasant year-round. Considerable tcsearch has been performed on estimated demand in consideration of expected larger demand durine the sammer and weekends. The cash flows of the van models difler duc to the frecast capacity and customer windows cnroifirations The comnanv's mimimum noweinat rate af nuturm is lipes Dhetaile of the NOTE TO CLASS: On the summary sheet, use the following formula for computing After Tax Cash flow: + After tax income + Depreciation expense. Don't use the depreciation shield (but calculate it). The way the schedule is set up (which is to calculate GAAP income and cash) is confusing in terms of using the depreciation shield. probilam Mangensent of lee Cold is ceatemplating the purphese of a nce ice cream trukk. The corppany plans to eutablish new rostes for cach of the tracks near the beaches in Southern California where the weather is pleakand year-rouad. Coskilerable reiemenh bas been performed en estimated demand in consideration of expected larper demand during the sumaner and wcekends. The cath flows of the vas models differ dae bs be freercr capocity and custiener. windows. specifications. The coatpany's minimum required mate of retans is 10%. Details of the purchace price of the vans is givea belser: Iastractiens? There are multiple parts is this problem. Lse liscel is perform the fothowing:- PART 15 Complete the table as rudtined in the morksheet tomanary All requircments are [istid as letters A through J ca that wuckibect. The table must be compated wing Eicel formalax; me menters are to be catered? PART 2a loe Cold eximates that it will tale veveral start-e years before the full reverect are achieved. It wath to calcelate fovesest bo loc ased for NPVIRRR analysis uking the following startup pencentar as. Years 3. 5 10x2= 104 ise 1 Calculate the NIV and IRR foe the foer madel. The learplate is ca the "Cash flows" worksheet. It Calcalate the pay back for the 4 madels. C. Cell refercmec your revults (NPV, IRRE Paghach) to the "reselts" teble in your "sunmary" workshect. PART 3: Creale a pisch tuble. The rows shoeld be the different sep was movele. Theee shotid be 5 colurnan * Initial imvetment Payback Income afler tax IRR sertinges is format the bortoen line as an averege. Management of lee Cold is contemplating the purchase of a nes ice cream truck. The company plans to establish Bew routes for each of the trucks near the bcaches in Southern Califorsia Where the weather is pleasant year-round. Considerable tcsearch has been performed on estimated demand in consideration of expected larger demand durine the sammer and weekends. The cash flows of the van models difler duc to the frecast capacity and customer windows cnroifirations The comnanv's mimimum noweinat rate af nuturm is lipes Dhetaile of the NOTE TO CLASS: On the summary sheet, use the following formula for computing After Tax Cash flow: + After tax income + Depreciation expense. Don't use the depreciation shield (but calculate it). The way the schedule is set up (which is to calculate GAAP income and cash) is confusing in terms of using the depreciation shield