Publication number: ELQ-87254-1
View all versions & Certificate
Cash Flow Statement Template in Excel
Cash Flow Statement Template in Excel containing a suggested list of profit and expenses items your business may have.
As noted in the short description, in this cash flow statement you will find a suggested list of expenses and profit items you may find within a typical business. All of these items can be modified by adding or removing rows and inputting your own items.To start, input the financial year at the top and in the first column enter your opening balance figure.
You should note that this particular statement assumes all figures are GST inclusive.
After you've entered your figures, the sheet automatically calculates your net profit and totals at the bottom. If you're removing or adding rows, you should double-check your numbers to make sure the calculations have been maintained.
Gross profit ÷ net sales = sales - cost of goods sold -any other expenses related to the production of a good or service.
Net profit = Gross profit ÷ net sales - Total expenses.
This cash flow statement is intended to be solely a guide and does not constitute as financial advice. You shold discuss and verify your financial statements with a financial advisor, qualified accountant, or a solicitor.
*Originally found on business.gov.au*
This business tool includes
1 Cash Flow Statement Template in Excel
Australian Government offers you this business tool for free!
download for free
Add to bookmarks
- Venkatesh P M(last updated: 13/11/2018 05:03)
- MBA Pablo J. Romero Guerrero(last updated: 11/11/2018 14:42)
- Maksym Melnychuk(last updated: 27/10/2018 21:12)
- Nut.Blue(last updated: 18/09/2018 07:29)
- Tom Juhl Petersen(last updated: 17/09/2018 16:53)
- Mahmoud Mostafa(last updated: 20/08/2018 18:21)
- Puleng Seakgwa(last updated: 23/07/2018 08:42)
- سیدعلی بنی طبا(last updated: 02/07/2018 15:09)
People using this tool also downloaded
Cash Flow Projection Worksheet in ExcelThis cash flow projection worksheet will help you to record your estimates of cash receipts and expenditures.businessprojectionsfinancemodelcash flowaccountingcash flow projection158 remove_red_eye
Annual Cash Flow ForecasterThis model is to help you forecast your cash flows for the next year. Built in excel with explanatory video included.yearlyprojectionssalescash flowcashtemplateexcelspreadsheetannual cash flowprojecting56 remove_red_eye
Cash Sweep Concepts Excel TemplateUnderstand the four concepts of cash sweeping.financemodeltemplateexceldownloadcash sweepconcepts879 remove_red_eyefreeby Michael Shane
Profit & Loss Statement Template in ExcelThis is a blank Profit & Loss Statement (or Income Statement) made in Excel.income statementaccountingexpensesfinancial statementtemplateexcelspreadsheetbookkeepingprofit and lossprofit and loss statement364 remove_red_eyefreeby Sarah Booysen
Cash Flow Statement Excel TemplateThis template provides you with a foundation to record operating, investing and financing cash flows annually.financecash flowfinancingoperatinginvestingcash flow statementstatement of cash flowscash flow template223 remove_red_eyefreeby CFI
Financial Model for Mobile Payment StartupIncludes assumptions page, income statement, balance sheet, cash flow statement and valuation sheet.income statementfinancemodelbalance sheetstartuptemplateexcelfreedownloadmobile1,951 remove_red_eyefreeby Tayfun Uslu
Due Diligence Assessment ModelAssessment of new business ventures across ten different dimensionsfinancemodeltemplateexcel1,255 remove_red_eye
Integrated Financial Statement TemplateA simple Full Pro Forma Financial Statement for Entrepreneursincome statementfinanceaccountingbalance sheetentrepreneurscash flow statementfinancial statementpro forma737 remove_red_eye
Excel Invoice TemplateThis Excel Template has a professional look and helps to streamline the process of invoicing in a company.businesstemplateexcelemployeesemploymentprocessesinvoicepaymentsNew!freeby Someka
Weekly Cash Flow Excel DashboardThis allows you to enter summaries or details of expected cash inflows/outflows daily.cash flowtemplateexcelspreadsheetsmeweeklydailycash flow dashboardcash flow builderrapid dashboard291 remove_red_eye
Any questions on Cash Flow Statement Template In Excel?
The user community and author are here to help. Go ahead!