Management Accounting
solomonongauh
1._CASHFLOWS_WORKINGS_Lab_2__2___ACC2125-AY1718_2.xlsxSheet1
| Cash Flow Statement | |||
| January | |||
| Opening Balance | -2675 | ||
| Inflows | |||
| Sales Revenue | 10250 | ||
| Total | |||
| Outflows | |||
| COS | -5000 | ||
| Expenses | |||
| Total | |||
| Net Cashflow | |||
| Closing Balance | |||
| Possible Overdraft |
Tasks Instructions: "Cashflow Statement sheet" - Calculate Inflows and Outflows for January and February using cell links between the worksheet. *Sales revenue is received in the month after the sale. *Cost of Sales are paid one month after the purchase *Other expenses are paid in the month that they are incurred *Calculate the opening cash balance for March *Using IF function give warning of possible overdrafts - Go to cell D21 select IF function, state IF the closing cash balance (D19) is below zero (D19<0) then show "Overdraft" if above zero show "+". *Format the Cashflows Statement for presentation to the directors. IF function breakdown- IF(logical test, "Value_if_true","Value_if_false") *Logical test = the condition, in this case if closing balance is less than 0 *"Value_if_true" = what will be stated if the logical test is true, in this case "Overdraft" *"Value_if_false" = what will be stated if the logical test is false, in this case "+"
Sheet2
| Workings | Sales Revenue Mark Up Percentage | 50% | |||||||||
| January | Sales Revenue received in the month after sale | ||||||||||
| Sales Revenue | |||||||||||
| Bedding Plants | |||||||||||
| Shrubs | |||||||||||
| Garden Furniture | |||||||||||
| Seasonal Gifts | |||||||||||
| Sales Revenue Total | |||||||||||
| Cost of Sales | COS Working | Paid one month after purchase | |||||||||
| Bedding Plants | 500 | Increase of 10% | |||||||||
| Shrubs | 2580 | Increase of 10% | |||||||||
| Garden Furniture | 1500 | Increase of 10% | |||||||||
| Seasonal Gifts | 250 | Discount of 20% | |||||||||
| COS Total | |||||||||||
| Gross Profit | |||||||||||
| Expenses | |||||||||||
| Wages | 2000 | 2000 | Paid in the month incurred | ||||||||
| Overheads | 750 | 750 | |||||||||
| Total Expenses | |||||||||||
| Net Profit |
Tasks Instructions: *Rename Sheet 1 to "Cashflows Statement" and rename Sheet 2 to "Workings" "Working sheet" - Calculate the net profit/loss for January and February *Use mark up given to calculate sales revenue using absolute cell referencing. *Use estimated percentage changes to COS.
Instructions
Tasks Instructions: *Rename Sheet 1 to "Cashflows Statement" and rename Sheet 2 to "Workings" "Working sheet" - Calculate the net profit/loss for January and February *Use mark up given to calculate sales revenue using absolute cell referencing. *Use estimated percentage changes to COS. "Cashflow Statement sheet" - Calculate Inflows and Outflows for January and February using cell links between the worksheet. *Sales revenue is received in the month after the sale. *Cost of Sales are paid one month after the purchase *Other expenses are paid in the month that they are incurred *Calculate the opening cash balance for March *Using IF function give warning of possible overdrafts - Go to cell D21 select IF function, state IF the closing cash balance (D19) is below zero (D19<0) then show "Overdraft" if above zero show "+". *Format the Cashflows Statement for presentation to the directors. IF function breakdown- IF(logical test, "Value_if_true","Value_if_false") *Logical test = the condition, in this case if closing balance is less than 0 *"Value_if_true" = what will be stated if the logical test is true, in this case "Overdraft" *"Value_if_false" = what will be stated if the logical test is false, in this case "+"
