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.
When you are ready, submit your Microsoft Word Document and Excel file on the Dropbox page. *Note, include your name in the file name of each Assignment.
Assignment checklist Items:
For help using the Dropbox, click on Academic Tools above then Dropbox Guide.
| Aspect | Percentage of assignment | Score | MT499 Assignment Criteria |
| Content, Focus, use of Research | 50% (30pts) | Addresses all assignment requirements, indicates depth of knowledge about the topics and key areas, contains a clear and concise introduction with a thesis statement, comprehension body of paper, closing summary, and includes a minimum of three cited and referenced resources (APA 6th edition). | |
Analysis and Critical Thinking | 30% (18pts) | Analysis and critical thinking indicates optimal reasoning with a defined purpose, based on assumptions, writer’s point of view, discusses the advantages and disadvantages, and uses data, information, and concepts/ideas to address the assignment topics or key areas in the paper. | |
Writing Style, Grammar, APA Format | 20% (12pts) | The capstone uses the APA (6th edition) writing style using active voice, which is in third person and concisely written. The paper is free from incorrect punctuation, use of jargon/clichés, incorrect grammar and mechanics, and is correctly formatted based on APA 6th edition guidelines. | |
| Total Points | 100% (60pts) |
ID: MT499-08-07-A
Explanation & Answer
Hello student ,kindly confirm the submitted answers. Thank you
Balance Sheet
Potter Jaz Music Inc.
Date:
Assets
Current Assets
Cash
Accounts receivable
Inventory
Prepaid expenses
Short-term investments
Total current assets
Fixed (Long-Term) Assets
Long-term investments
Property, plant, and equipment
(Less accumulated depreciation)
Intangible assets
2014
2015
2016
22.000
650
1.000
23.650
17.000
200
1.000
18.200
32.800
300
1.000
34.100
100.000
90.000
(2.200)
70.000
90.000
(2.200)
50.000
90.000
(2.200)
Total fixed assets
187.800
157.800
137.800
Total Other Assets
-
-
211.450
176.000
171.900
79.000
450
1.000
59.000
500
1.000
49.000
450
1.000
80.450
60.500
50.450
115.000
100.500
99.500
115.000
100.500
99.500
11.000
5.000
11.000
4.000
10.000
11.950
16.000
15.000
21.950
211.450
176.000
171.900
Other Assets
Deferred income tax
Other
Total Assets
[42]
-
-
Liabilities and Owner's Equity
Current Liabilities
Accounts payable
Short-term loans
Income taxes payable
Accrued salaries and wages
Unearned revenue
Current portion of long-term debt
Total current liabilities
Long-Term Liabilities
Long-term debt
Deferred income tax
Other
Total long-term liabilities
Owner's Equity
Owner's investment
Retained earnings
Other
Total owner's equity
Total Liabilities and Owner's Equity
{42}
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 activit...
