Carry out a proforma analysis on excel sheet of the figures of Tesco with the following changes: The receivables for 2015/16 should be £1,607 and the "Other current assets" should be £3,630. The total...

Carry out a proforma analysis on excel sheet of the figures of Tesco with the following changes:

1. The receivables for 2015/16 should be £1,607 and the "Other current assets" should be £3,630. The total current asset amount £14,828 is correct and matches the actual Tesco's BS for that year.

2. The company hasn't paid any dividends in 2015/16 nor 2014/15. You can assume dividend payout ratio on your own. Just keep in mind that for a struggling company, it would be nowhere near the 60% level. Something like 10-15% would be more reasonable. Also, remember, companies do not pay dividends if they end up with a net loss.

3. A net loss may result in a tax break (a refund, essentially) for several years, which explains negative values for taxes in 2015/6 and 2014/5 income statements. These
   should not
   be used in estimating the tax rate. Only the values for years with positive profit and taxes (2010/11 through 2013/14) are appropriate for estimating the average tax rate.

Then do a memo on word document with the financial analysis of Tesco Co. The memo should discuss the present situation(2-3sentences very brief), suggest a course of action, and analyze financial implications thereof(bulk of the memo). Calibri body font size 12 space 1.5 maximum 3 pages. The memo should be formal and written in 3rd passive voice. Normal writing, no specific style.