please help thank you so much

recommend to use Excel tor your assignment, If you do it bv hand, please make sure that you present your responses in a clean and professionally looking Way. Assume that this is a report that you are presenting to a supervisor or a departrncnt Qai_sv Cakes san ABC Shark Please Watch thc Video and answer the following questions: I) HOB' much money did Kim get from the deaP What Were thc conditions tied to it? 2) Based on the deal, What is the value/price of the company? 3) Prepare a balance sheet after the deal. What are the assets. the liabilities and the Equity? Separate thc Equity section into Kim's and Barbara"; equity in the company. For the valuation Of the liability (what DaisyCakes has to pay to Barbaral use your knowledge about time value of money. Assume a discount rate. Hint: Round the numbers of cakes sold per year to the next full IOOs. 4) "Guesstimate" the company's current annual sales. and net income. Prepare a budgeted Income Statement. We do not really know how if the SIB cost kim quotes include things like the electricity, depreciation or a to Kim. herself. her mother. So. for now. let's go with the information wc got from the video. 5) Based on this Balance Sheet and Income Statement. calculate the profit Margin and ROI and Residual Income (assume 10%) for the overall company Barbara's inve"itment. 6) Based on your findings above. what is the actual valuation Of the company? In other words. what are the Net Assets? I have also found a couple of updates on the Daisy Cakes Business after the Shark Tank episode. in case you are here you go.