calculate the cash budget income statement and balance sheet using the excel templates provided

by

Kindly calculate the Cash Budget, Income Statement and Balance Sheet using the Excel templates provided. Textual headings in this template are protected. They contain all the headings you need to complete the assignment and should therefore remain protected.

– Only the cells coloured in YELLOW should be completed.

– You might use other excel sheets as workings, or use the additional sheets in the Excel template,

– Please do not change any of the text or format of any of the textual cells, nor move any of the three statements (cash budget, income statement or balance sheet) into different sheets in excel.

The excel sheet is attached along with the case scenario (pdf file).