Description
This two-part project will focus on the financial aspects of your start up business. This project also includes the use of Excel spreadsheets containing financial data and required reports.
Before you begin, take this tutorial on financial statements.
In part I, using Microsoft Excel worksheets create 3 years of income statements, balance sheets, and cash flow statements.
In part 2, using Microsoft Word®, create a 3–4 page financial summary detailing your income statements, balance sheets, and cash flow statements.
Explanation & Answer
Attached.
Statement of Cash Flows
© www.excel-skills.com
Cash flows from operating activities
Cash receipts from customers
Cash paid to suppliers and employees
Cash generated from operations
Interest paid
Income taxes paid
2016
2015
31,150.00
(29,190.00)
1,960.00
(270.00)
(300.00)
26,015.00
(25,630.00)
385.00
(280.00)
(45.00)
1,190.00
60.00
(350.00)
70.00
400.00
(430.00)
(200.00)
(500.00)
350.00
(350.00)
Proceeds from long-term borrowings
Payment of long-term borrowings
Net cash used in financing activities
250.00
(190.00)
310.00
200.00
(70.00)
130.00
Net increase in cash and cash equivalents
1,070.00
(160.00)
160.00
320.00
1,230.00
160.00
Net cash from operating activities
Cash flows from investing activities
Purchase of property, plant and equipment
Proceeds from sale of equipment
Acquisition of portfolio investments
Investment income
Net cash used in investing activities
Cash flows from financing activities
Cash and cash equivalents at beginning of period
Cash and cash equivalents at end of period
Cash Balance Control Total
Notes to the Statement of Cash Flows
Cash flows from operating activities
Profit before taxation
Adjustments for:
Depreciation
Investment income
Interest expense
Profit / (Loss) on the sale of property, plant & equipment
Working capital changes:
(Increase) / Decrease in trade and other receivables
-
-
2016
2015
4,350.00
1,230.00
450.00
(500.00)
400.00
(50.00)
260.00
(350.00)
300.00
-
(500.00)
(505.00)
(Increase) / (Decrease) in inventories
Increase / (Decrease) in trade payables
Cash generated from operations
(450.00)
(1,740.00)
1,960.00
(750.00)
200.00
385.00
2014
51,000.00
(22,000.00)
385.00
(200.00)
(70.00)
785.00
(200.00)
300.00
(500.00)
300.00
(50.00)
250.00
(160.00)
320.00
160.00
2014
2,450.00
260.00
(230.00)
300.00
(505.00)
(750.00)
200.00
890.00
[Your Company Name]
or the Year Ended [Mmmm Dd, 200X]
Potter Jaz Musi Inc.
Income Statement
For the year Ended Decemer 31, 2014
Revenue:
Gross Sales
Less: Sales Returns and Allowances
Net Sales
...