Thanks for helping Issy to open her first store and make the necessary adjustments.Issy is excited about the opportunity this store has presented to her.She now wants to open five additional stores for which she has identified sights in the greater metro area. Her quandary is whether to open each new store with the available cash flows of the previous stores (thus retaining full ownership) or to accept an offer from a potential partner to fully fund the additional stores and open them right now (beginning of second year).However, the potential partner wants 40% ownership of all stores from the beginning (even store 1,retroactively).She has prepared estimated free cash flows for each option (see below, link) for each year of the ten year period, including the end of the first year.If you are comparing options bring your calculations back to the year one, since if she takes a partner all ownership will be retroactive.The cashflows given are specific to that year, meaning that the year 1 amount is that much more or less than she had in year 0 (which was 0), year 2 was how much more or less than she had in year 1, etc.In other words, that which was generated or consumed that year, they are NOT cumulative.

Tell her under which option she would be financially better off and why (must submit spreadsheet and explanation).Hint:How do you compare two dissimilar cashflows over time time? (Professor does not give a discount rate for NPV.

Annual After Tax Cash Flows Year 1 Year 2 Year 1 Year 4 Year S Year & Year 7 Year & Year 9 These are the additional flows brought Year 10 in each year. hay Roles out 5 additional stores S 48.190 $ 126884 $ (77821) 5 96.841 $ (95.664) 5 804,541 5 944,095 $ as cash is available 955,625 5 1.088.221 $ 1.132,552 bay takes on a 40% partner and S 48.190 5 484.601 5 880595 5 798.514 $ 987.963 5 1.039,003 5 1,071 697 $ 1.147,203 5 1.193.937 5 1.242.575 Starts all 5 stores the second year She only owns 60's of these flows)