Please use the excel file (attached) for this short project and assume that this is the end of 2020. The forecasting period is from 2021 to 2025. After 2025, use perpetual growth rate. Assume that you are the owner of 5 small grocery stores that sell products in the neighborhood. You are earning consistent profit every year and you plan to open some new stores each year in different locations for the next 4 years (Please check the operation assumption below). Remember that it takes a year to earn revenue from the new stores as you need a year to build out stores. You assume that once the store is open, you will be able to earn $50,000 per year from each store (this is what you earn now from each of the existing store). The cost to build each store is $70,000 (CAPX). You have a plan to recognize the cost by depreciating the existing property, plant and equipment by 20% each year. The cost of goods sold (COGS) and the selling, general and administrative expenses (SG&A) are 25% of revenue and $5,000 per store respectively. You assume that these costs will continue for the existing number of stores. Accounts receivable, inventories and accounts payable are $4,000, $9,000 and $6,000 per store respectively, and these costs are assumed to be continued for the total number of stores at the end of the year. The income tax rate is 21%. Also, assume that the discount rate is 15% and the growth rate after 2025 is 4%.

Based on the above information, answer the following questions. a) Calculate net operating profit after taxes (NOPAT) from 2020 to 2025 b) Calculate net working capital (NWC) from 2020 to 2025 c) Calculate free cash flow (FCF) from 2021 to 2025 d) Calculate the terminal value. e) Calculate the value of the start-ups. f) Keeping everything else similar, assume that the depreciation is 15% of the existing property, plant and equipment. What is the value of the start-ups? (show the calculation in another excel file) g) Keeping everything else similar, if the cost of goods sold is 40%, what is the value of the start-ups? (show the calculation in another excel file) Note: You will submit three excel files

C 76% Ger A candinating Fatwa Style S De- 12 Formal Cente Pont A Numb Fana DI A Growth rate after 2025 2 Tax Rate Discount Rate per More of perdere of existing property. Blant and equipments Valuation the call or the end of 2000 The other 30012035. Aer 2015 septe Ato you the worst wird You provery and you may different was deterio below Werthomewors you to build out your here to earn $50,000 per year from www from or the cost echo $70.000 loge the cost by the property by year Theo GDG dengan 29 of 8.000 per ore you that the wild for ther And bar.00 $9,000 and 6.000 espectively, and then be continued for the of and of the year. The women 2. hehe dette er 2005 Open 305 3 5 13 14 . 3 4 2 wand 14 per store persone pere per te 5 Revenues Cost of Goods Sold 7SGB Depression 9 10 CAPX 13 Accounts Receivable 12 mentories 13 Accounts Payable 14 15 16 Operation Asumptions 17 18 Existing Stores 19 New Stores 20 Total Stores end of year) 21 22 23 24 2020 2021 2022 OM 16 16 on these were allowing Culote et petrol (NOPAT) 2000 to 2005 Callewing from 2020 2025 date clown from 2005 Catate the termale # te the line See wegen het eers of the entire ped value of the weation re Kweg of what the wheel shower www 2 27 30 11 2 14 15 Assumption