Microsoft Excel worksheets, management homework help

User Generated

QrerxGnlybe

Business Finance

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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
...

Related Tags