SPREADSHEET FOR USE IN ASSIGNMENT 1 -'CASH A B C D E F G H ! 1 K L M 1 CASH FLOW FORECAST - Jan to Dec 1990 2 3 4 5 S G Jan Feb Mar Agr May June Aug Sept Oct Nov Dec Total 7 INCOME a 9 Repairs 6100 6250 6950 7250 9050 10100 9150 8160 700 5500 10 Petrol 2000 2020 2100 2500 2750 3500 2750) 2600 2340 1900 2450 11 12 Total Income 13 14 75 EXPENDITURE 16 17 Purchase: 18 5620 6000 5400 4758 4090 Spare parts Petrol 13660 3750 4170 4350 1500 1500 1575 1800.2 19 2600 2345.9 2652 1987 1876.9 20 Waces 2000 2000) 2000 2000 2000 2000 2000) ZOXID 2000 XI0 2010 21 Electricity 500 S00 SOX) 500 22 Rent 600 600 600 600 600 600 b00 60X 600 EXO 60 23 Rates 500 SOO 24 Telephone 150 150 150 150 25 postage 20 20 20 20 20 20 20 20 20 20 20 25 Accountant 450 27 Sundries 20 20 20 20 20 20 20 20 20 20 20 28 29 Total Expanditure 3D 31 32 PROFIT Note: As well as entering the values shown above the Tutor at the Centre is required to:- I. Add suitable formulae in Rows 12 and 29 and in Column M to calculate the totals. Insert suitable formulae into row 32 to calculate the profit. 11. The spreadsheet supplied 'CASH', comprises details of Income and Outgoing for a garage; these figures can be used to predict the profit month by month. . Using spreadsheet supplied, 'CASH', you are required to answer the following questions: Question 1. Examine the sheet and print out the formulae stored in some of the celis and also prints out a draft copy of the worksheet, this printout should show the cell addresses, before making and changes. Question 2 Insert a column for the month of July, income for July can be estimated by taking the average September and May, outgoing should be made equal to those October. Print out the amended spreadsheet. Question 3. Extend the spreadsheet to cover the next three months. Assume a 10% increase of income is achieved each month. Outgoing remain static, as in December. Print contents and values of the amended sheet. SPREADSHEET FOR USE IN ASSIGNMENT 1 -'CASH A B C D E F G H ! 1 K L M 1 CASH FLOW FORECAST - Jan to Dec 1990 2 3 4 5 S G Jan Feb Mar Agr May June Aug Sept Oct Nov Dec Total 7 INCOME a 9 Repairs 6100 6250 6950 7250 9050 10100 9150 8160 700 5500 10 Petrol 2000 2020 2100 2500 2750 3500 2750) 2600 2340 1900 2450 11 12 Total Income 13 14 75 EXPENDITURE 16 17 Purchase: 18 5620 6000 5400 4758 4090 Spare parts Petrol 13660 3750 4170 4350 1500 1500 1575 1800.2 19 2600 2345.9 2652 1987 1876.9 20 Waces 2000 2000) 2000 2000 2000 2000 2000) ZOXID 2000 XI0 2010 21 Electricity 500 S00 SOX) 500 22 Rent 600 600 600 600 600 600 b00 60X 600 EXO 60 23 Rates 500 SOO 24 Telephone 150 150 150 150 25 postage 20 20 20 20 20 20 20 20 20 20 20 25 Accountant 450 27 Sundries 20 20 20 20 20 20 20 20 20 20 20 28 29 Total Expanditure 3D 31 32 PROFIT Note: As well as entering the values shown above the Tutor at the Centre is required to:- I. Add suitable formulae in Rows 12 and 29 and in Column M to calculate the totals. Insert suitable formulae into row 32 to calculate the profit. 11. The spreadsheet supplied 'CASH', comprises details of Income and Outgoing for a garage; these figures can be used to predict the profit month by month. . Using spreadsheet supplied, 'CASH', you are required to answer the following questions: Question 1. Examine the sheet and print out the formulae stored in some of the celis and also prints out a draft copy of the worksheet, this printout should show the cell addresses, before making and changes. Question 2 Insert a column for the month of July, income for July can be estimated by taking the average September and May, outgoing should be made equal to those October. Print out the amended spreadsheet. Question 3. Extend the spreadsheet to cover the next three months. Assume a 10% increase of income is achieved each month. Outgoing remain static, as in December. Print contents and values of the amended sheet