Financial Statement Analysis MG 770 Final Exam – Fall 2014 Part 2 – Problem Solving

Financial Statement Analysis MG 770 Final Exam – Fall 2014 Part 2 – Problem Solving

Financial Statement Analysis

MG 770

Final Exam – Fall 2014

Part 2 - Problem Solving –

All Answers to be submitted on Excel Answer Sheet

(show work or use formulas when appropriate)

Use the following information about XYZ Plumbing (FY=12/31), a public company with the most recent

closing stock price of $5.00, to answer the following three problems
	

-
	

	

	

	

	

------------------------------------------------------------------------------------------------------

Income Statement
	

	

	

	

	

	

	

	

	

	

	

	

	

	

	

	

	

	

	

	

2012
	

	

	

	

2013
	

	

	

Revenue
	

	

	

$
	

	

10,000,000
	

	

$
	

12,000,000
	

	

	

CGS
	

	

	

	

	

	

4,000,000
	

	

	

	

4,800,000
	

	

	

Gross Profit
	

	

	

$
	

	

6,000,000
	

	

$
	

7,200,000
	

	

	

SG&A
	

	

	

	

	

	

1,800,000
	

	

	

	

2,000,000
	

	

	

R&D
	

	

	

	

	

	

1,000,000
	

	

	

	

1,000,000
	

	

	

Deprec & Amort
	

	

	

	

	

	

500,000
	

	

	

	

550,000
	

	

	

Total Op. Expense
	

	

	

	

	

	

3,300,000
	

	

	

	

3,550,000
	

	

	

Operating Profit
	

	

	

$
	

	

2,700,000
	

	

$
	

3,650,000
	

	

	

Interest cost
	

	

	

	

	

	

520,000
	

	

	

	

600,000
	

	

	

Interest income
	

	

	

	

	

	

90,000
	

	

	

	

110,000
	

	

	

Pre-Tax
	

	

	

$
	

	

2,270,000
	

	

$
	

3,160,000
	

	

	

Tax (35% rate)
	

	

	

	

	

	

794,500
	

	

	

	

1,106,000
	

	

	

Net Income
	

	

	

$
	

	

1,475,500
	

	

$
	

2,054,000
	

	

	

EPS - Basic
	

	

	

$
	

	

0.15
	

	

$
	

0.21
	

	

	

Average Shares Outstanding
	

	

	

	

10,000,000
	

	

	

	

10,000,000
	

	

	

Balance Sheet
	

	

	

	

	

	

	

	

	

	

	

	

	

	

	

2012
	

	

2013
	

	

	

	

	

	

2013
	

	

2013

ASSETS
	

	

	

	

	

	

LIABILITIES
	

	

	

	

Cash
	

3,000,000
	

	

4,154,000
	

	

Accounts Payable
	

	

	

500,000
	

500,000

A/R
	

1,000,000
	

	

1,500,000
	

	

Notes Payable
	

	

	

1,500,000
	

	

1,000,000

Inventory
	

2,000,000
	

	

2,300,000
	

	

Current portion of LTD
	

1,000,000
	

	

1,000,000

Pre-paid expenses
	

	

500,000
	

670,000
	

Accrued Liabilities
	

500,000
	

520,000

Total Current Assets
	

	

6,500,000
	

	

8,624,000
	

	

Total Current Liabilities
	

3,500,000
	

	

3,020,000

Building and Improvements
	

15,000,000
	

	

15,000,000
	

	

Long-Term Debt
	

	

	

12,000,000
	

	

14,000,000

Equipment
	

5,000,000
	

	

7,000,000
	

	

	

	

	

	

	

	

	

	

	

20,000,000
	

	

22,000,000
	

	

Stockholder's Equity
	

	

	

	

	

	

	

	

	

	

	

Common Stock at Par
	

100,000
	

100,000

Depreciation
	

	

500,000
	

1,050,000
	

	

Paid in Capital
	

	

	

9,900,000
	

	

9,900,000

Net PP&E
	

	

19,500,000
	

	

20,950,000
	

	

Retained Earnings
	

	

	

500,000
	

2,554,000

	

	

	

	

	

	

	

Total Stockholder's Equity
	

10,500,000
	

	

12,554,000

Total Assets
	

26,000,000
	

	

29,574,000
	

	

Total Liabilities + Equity
	

26,000,000
	

	

29,574,000


Financial Statements - Final Exam Fall 2014 - 1 -

1. (26 Points)

Complete the following cash Flow Statement for XYZ Plumbing for 2013

Statement of Cash Flows
	

2013

Net Income

Adjustments

Depreciation and amortization

Cash Provided by Operating Assets and Liabilities

Accounts Receivable

Inventories

Pre-paid expenses

Accounts payable

Accrued liabilities

Net Cash provided (used) by operating activities

Cash Provided from Investing Activities

Additions to property, plant and equipment

Net Cash provided (used) by investing activities

Cash Provided from Financing Activities

Additions to long term borrowing

Addition to short term borrowing

Net Cash provided (used) by financing activities

Net Cash Flow

2. ( 6 Points)

Calculate the following ratios for 2013:

2013

Current Ratio

Accounts Receivable turnover Inventory turnover

Revenue to Cash Return on Assets Return on Equity


Financial Statements - Final Exam Fall 2014 - 2 -

3. (18 Points,1 point for each correct box except diluted shares - 6 points)

3.) Fill in the projections for XYZ for 2003, based on the following assumptions:

1. Revenue grows by 20% between 2013 and 2014.

2. Gross Margins remain at 2013 levels.

3. SG&A improves by 1% (as a % of revenue)

4. R&D increases by 20%.

5. Depreciation and Amortization costs do not change between 2013 and 2014.

6. Interest costs and expenses are given in the table.

7. The tax rate remains constant.

8. Options and Warrants are listed in the following table:

Options
	

	

Amount
	

	

Exercise Price
	

	

Public Warrants
	

Amount
	

	

Exercise Price

Officers and Directors
	

	

2,000,000
	

	

$2.00
	

	

Shareholders
	

	

4,000,000
	

	

$3.00
										

2014E

Revenue CGS

Gross Profit

SG&A

R&D

Deprec & Amort

Total Op. Expense

Operating Profit

Interest cost

Interest income

Pre-Tax

Tax (35% rate)

Net Income

EPS - Basic

EPS - Diluted


Financial Statements - Final Exam Fall 2014 - 3 -

In the figure, a proton is projected horizontally midway between two parallel plates that are separated by 0.3 cm. The electrical field due to the plates has magnitude 4.5×105 N/C between the plates away from the edges. If the plates are 4.4 cm long, find the minimum speed of the proton if it just misses the lower plate as it emerges from the field. (e = 1.60 × 10-19 C, ? 0 = 8.85 × 10-12 C2/N · m2, m el = 9.11 × 10-31 kg).

In the figure, a proton is projected horizontally midway between two parallel plates that are separated by 0.3 cm. The electrical field due to the plates has magnitude 4.5×105 N/C between the plates away from the edges. If the plates are 4.4 cm long, find the minimum speed of the proton if it just misses the lower plate as it emerges from the field. (e = 1.60 × 10-19 C, ? 0 = 8.85 × 10-12 C2/N · m2, m el = 9.11 × 10-31 kg).

In the figure, a proton is projected horizontally midway between two parallel plates that are separated by 0.3 cm. The electrical field due to the plates has magnitude 4.5×105 N/C between the plates away from the edges. If the plates are 4.4 cm long, find the minimum speed of the proton if it just misses the lower plate as it emerges from the field. (e = 1.60 × 10-19 C, ? 0 = 8.85 × 10-12 C2/N · m2, m el = 9.11 × 10-31 kg).

Prepare a two- to three-page paper in APA style that…

Prepare a two- to three-page paper in APA style that…

Prepare a two- to three-page paper in APA style that describes, explains, addresses, and answers the following questions or statements.
What cultural factors must U.S. sports franchises overcome to increase popularity abroad? Why? 
How can franchises ensure its products are appropriate for international markets? 
Should governments protect its industries by placing tariffs on imported products? Why? Why not? 
Include APA style in-text citations as well as a reference section. 
Additional Requirements 

Level of Detail: Only answer needed

Week 2 – Individual Assignment – ITPR429-1302B-01

Week 2 – Individual Assignment – ITPR429-1302B-01

Based on your research and past discussion with your design team, write a 3–4-page network design plan for the online banking system.
1. Choose a network design pattern. 
Review the 2 network design patterns you were considering.
Choose the best one, and explain your reasoning for your choice. 
2. Add solutions for concerns. To alleviate security and performance/optimization concerns, do the following: 
List the 3–6 most important security and performance/optimization solutions you plan to implement.
Explain how you will include each of these in your network design. 
3. Update the network design pattern outline or diagram. 
Add to or revise your online banking network design pattern outline or diagram based on all the information you currently have.
Include each of the following elements:  
all necessary physical and logical layers
an explanation of whether the implementation will be a Web-based or application-based system
solutions for the 3–6 most important security and performance/optimization concerns 

System Management Paper

System Management Paper

Do the process and actions associated with "Mental Mastery" preclude someone from enacting the "Seven Habits of Highly Effective People"? Are these two approaches to one’s personal and professional wellbeing directly opposed to each other, or can they be made to work in concert? 2 pages, APA format.

rebuttal

rebuttal

a 350- to 700-word rebuttal to the article using valid arguments and supporting data. In the rebuttal, offer an analysis:

Biochemistry question

Biochemistry question

Biochemistry question

Regulation of Ribonucleotide Reductase by Deoxynucleoside Triphosphates
Derek T Logan (2011) Nature Structure & Molecular Biology 
The regulation of Ribonucleotide Reductase (the enzyme responsible for the conversion of the four standard ribonucleotides to their 2-deoxyribonucleotide counterparts) is of prime importance. Please detail and fully describe the binding of effector molecules on the activity and specificity of this enzyme. Why is this unique type of regulation so critical? 

Role of Ethics in Business

Role of Ethics in Business

Week 2 Assignment: Interpret the Role of Ethics in Business

Activity Description

What is the role of ethics in business? Prepare a paper that addresses the following:

Evaluate the concept of ethics as it relates to business operations. Be certain to utilize your text’s definition and then compare and contrast definitions from other sources.
What stance does Drucker take on ethics?
How does your text author relate Carr’s perspective regarding the role of ethics in business?
Provide your own perspective: are personal ethics and business ethics really different? Why or why not?
Support your paper with minimum of three (3) scholarly resources. In addition to these specified resources, other appropriate scholarly resources, including older articles, may be included.

Length: 5-7 pages not including title and reference pages

Your paper should demonstrate thoughtful consideration of the ideas and concepts presented in the course and provide new thoughts and insights relating directly to this topic. Your response should reflect scholarly writing and current APA standards. Be sure to adhere to Northcentral University's Academic Integrity Policy.

Upload your assignment using the Upload Assignment button below.



Learning Outcomes

2.0 Compare and contrast the perspectives of various parties who influence business decisions.
3.0 Assess the conflicting objectives of those who influence ethical business decisions. 

charismatic leadership

charismatic leadership

Although charismatic leaders can use their abilities to accomplish great things, there are also concerns about charismatic leadership from a moral standpoint. Choose a position, either (1) charismatic leaders accomplish great things, or (2) there are moral concerns with charismatic leaders. Select a recent article from current events (past 90 days) supporting your position. Write a well-written presentation on this topic by providing a paragraph summarizing the primary components of the article and a second paragraph presenting your analysis of the article (Do you agree/disagree? Is it congruent with our text? Why/why not? Etc.). Be certain to provide a complete reference (APA) for the selected article.