The bank balance at the beginning of the first month

This preview shows page 29 - 35 out of 48 pages.

The bank balance at the beginning of the first month is estimated to be $30 000. Required: 1. Show the profit and loss calculations for April, May and June of operations. 2. Show the cash flow projection calculations for April, May and June. 3. Show amended figures if sales were to increase by 10% in each month and the cost of goods fell from 40% to 35% through a better long-term purchasing agreement with the supplier. Managing Finance, Assessment 1 Portfolio Page 29 V2 Last updated on 11/03/2019
BSBFIM501 Manage budget and financial plans 4. Does Peter need to suggest any contingency plan at this stage?
Managing Finance, Assessment 1 Portfolio Page 30 V2 Last updated on 11/03/2019
BSBFIM501 Manage budget and financial plans Opening Cash Plus cash in: This month From last month From two months ago Total Cash available less cash out: salaries Commission Other expenses COGS Total cash out Closing cash balance Amended Profit and Loss calculations April May June $ $ $ Managing Finance, Assessment 1 Portfolio Page 31 V2 Last updated on 11/03/2019
BSBFIM501 Manage budget and financial plans Sales Less Cost of Goods Sold Gross Profit Sales Salaries Commission Other expenses Total expenses Net Profit Amended Cash flow projections April May June $ $ $ Managing Finance, Assessment 1 Portfolio Page 32 V2 Last updated on 11/03/2019
BSBFIM501 Manage budget and financial plans Opening Cash Plus cash in: This month From last month From two months ago Total Cash available less cash out: Salaries Commission Other expenses COGS Total cash out Closing cash balance Task 25: Constructing a Cash Flow Statement (1 Mark) Constructing a Cash flow statement: Managing Finance, Assessment 1 Portfolio Page 33 V2 Last updated on 11/03/2019
BSBFIM501 Manage budget and financial plans Calculate the total cash inflows and cash outflows and the net cash position at the end of December from the following information: Use the space provided and shows all line items. XYZ Pty Ltd. December 2019 Particulars Amount ($) Cash receipts from customers 235,000 Cash paid to suppliers and employees 121,570 Interest paid 34,120 Income tax paid 29,910 Purchase of Subsidiary X, net of cash acquired 550000 Purchase of property, plant and equipment 450,100 Proceeds from sale of equipment 20,000 Interest received 12,550 Dividends received 35,654 Proceeds from issue of share capital 250,000 Proceeds from long-term borrowings 250,000 Payment of finance lease liabilities 90,000 Dividends paid 135,700 Cash and cash equivalents at beginning of period 430,750
Managing Finance, Assessment 1 Portfolio Page 34 V2 Last updated on 11/03/2019

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture