Excersize completed fin 4-1
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
325
Subject
Finance
Date
Feb 20, 2024
Type
docx
Pages
8
Uploaded by MajorBear878
FIN 325 Exercise Two Handout
Liquidity Ratios
Current Ratio
= Current Assets / Current Liabilities
114,246,000
/
45,625,000
=2.50
1)
Quick Ratio
= (Current Assets − Inventory) / Current Liabilities
(
114,246,000
-
2,660,000)
/
45,625,000 = 2.45
Leverage Ratios
2)
Long-term Debt/Equity Ratio
= Long-term Debt / Equity
20,645,000 /
89,784,000=23%
3)
Total Debt/Equity Ratio
= (Short-term Debts + Long-term Debts) / Equity
(20,645,000
+ 2,000,000)/
89,784,000=25.22%
Profitability Ratios
4)
Net Profit Margin
= Net Profit after Taxation / Sales
22,074,000/
86,833,000 =25.42
5)
Operating Profit Margin
= Operating Profit / Sales
27,759,000 /86,833,000= 31.97%
6)
Return on Equity
= Net Profit after Taxation / Equity
22,074,000/
89,784,000=24.59%
7)
Return on Total Assets
= Net Profit after Taxation / Total Assets
22,074,000/
172,384,000 =12.81%
8)
Return on Capital Employed
= Net Profit after Taxation / (Total Assets − Current Liabilities)
22,074,000(
172,384,000 - 45,625,000) =
22,074,000/126,759,00=17.41%
Efficiency Ratios 9)
Inventory Turnover
= Sales / Inventory
86,833,000 /
2,660,000=32.64
10) Assets Turnover
= Sales / Total Assets
86,833,000 /172,384,000 =0.50
Market Value Ratios
11) Price Earnings Ratio
= Current Stock Price / Earnings Per Share (EPS)
46.72/0.32=146
Other Fundamental Indicators
12) Earnings Per Share (EPS
) = Net Profit after Taxation / Issued Common Shares
22,074,000/68,366,000 = 0.32
13) Net Asset Value (NAV)
= (Total Assets − Total Liabilities) / Issued Common Shares
(
172,384,000 -82,600,000)/
68,366,000 =1.31
FIN 325: Microsoft Corporation (MSFT)
46.71
0.74(1.61%) 6/18/15 3:25PM EDT - Nasdaq Real Time Price
Income Statement
All numbers in thousands; Currency in USD
Period Ending
Jun 30, 2014
Jun 30, 2013
Jun 30, 2012
Total Revenue
86,833,000
77,849,000
73,723,000
Cost of Revenue
26,934,000
20,249,000
17,530,000
Gross Profit
59,899,000
57,600,000
56,193,000
Operating Expenses
Research Development
11,381,000
10,411,000
9,811,000
Selling General and Administrative
20,632,000
20,425,000
18,426,000
Non Recurring
127,000
-
6,193,000
Others
-
-
-
Total Operating Expenses
-
-
-
Operating Income or Loss
27,759,000
26,764,000
21,763,000
Income from Continuing Operations
Total Other Income/Expenses Net
61,000
288,000
504,000
Earnings Before Interest And Taxes
27,820,000
27,052,000
22,267,000
Interest Expense
-
-
-
Income Before Tax
27,820,000
27,052,000
22,267,000
Income Tax Expense
5,746,000
5,189,000
5,289,000
Minority Interest
-
-
-
Net Income From Continuing Ops
22,074,000
21,863,000
16,978,000
Non-recurring Events
Discontinued Operations
-
-
-
Extraordinary Items
-
-
-
Effect Of Accounting Changes
-
-
-
Other Items
-
-
-
Net Income
22,074,000
21,863,000
16,978,000
Preferred Stock And Other Adjustments
-
-
-
Net Income Applicable To Common Shares
22,074,000
21,863,000
16,978,000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Ratio
Industry Ratios
GnG Ratios
1. Current Ratio
5.3
7.08
2. Acid Test Ratio
5.1
6.8
3. Gross Profit Ratio
30%
40%
4. Net Income Margin
7.5%
18.2%
5. Receivable Turnover Ratio
9
14.41
6. Return on Asset Ratio
12%
9.29%
7. Debt to Asset Ratio
1:4
1 : 1
Interpretation and verbal analysis compared to industry ratios:
1. Liquidity
2. Profitability
3. Solvency
arrow_forward
Industry
Ratios
Ratio
GnG Ratios
1. Current Ratio
5.3
7.08
2. Acid Test Ratio
5.1
6.8
3. Gross Profit Ratio
30%
40%
4. Net Income Margin
7.5%
18.2%
5. Receivable Turnover Ratio
14.41
6. Return on Asset Ratio
12%
9.29%
7. Debt to Asset Ratio
1:4
LA 1
Interpretation and verbal analysis compared to industry ratios:
Liquidity
1.
2.
Profitability
3.
Solvency
arrow_forward
Data needed: SFP Asset section
1. Cash 16.3%
2. AR 6.3%
3. Short term investment 0.2%
4. Inventory 2.2%
5. Prepaid expenses 0.4%
6. PPE 74.7%
Data needed: SFP Liabilities and OE
section.
1. Current liab 16%
2. Non-current liab 34.2%
3. OE 49.9%
Data needed: SCI
1. COGS 38.6%
2. Selling and admin exp 6.8%
3. Interest exp 0.1%
4. Income tax exp 0.5%
5. Net income 54%
arrow_forward
Calculate any 5 leverage ratio
arrow_forward
General Accounting Question Pls Need Answer with given option
arrow_forward
Ratio
Industry
GnG Ratios
Ratios
1. Net Income Margin
7.5%
18.2%
2. Receivable Turnover Ratio
9.
14.41
3. Return on Asset Ratio
12%
9.29%
4. Debt to Asset Ratio
1:4
1:1
Interpretation and verbal analysis compared to industry ratios:
1. Liquidity
2. Profitability
3. Solvency
arrow_forward
2. Calculate the financial leverage - equity multiplier and cash cover ratio
arrow_forward
Q#2:Debt to Assets Ratio Debt to Equity Before-tax cost of debt0.0 0 6%0.1 0.11 7%0.2 0.25 9%0.3 0.43 12.5%0.4 0.66 15.5%Krf= 3%, Market Risk Premuim = 5%, T=30%, BUL = 0.9.Required: Determine, its capital structure.
Q#3: A firm has 20 million shares outstanding, with a $30 per share market price. The firm has $10million in extra cash that it plans to use in a stock repurchase;…
arrow_forward
Qb 08.
arrow_forward
1
2 Debt Ratio (current)
3 Equity Ratio (current)
4 Cost of Debt
5
Market Risk Premium
6 Equity Beta
7 Debt Beta
8 Risk Free Rate
9 Corporate Tax Rate
10
11
12 a. Cost of Equity
13 b. WACC
14 c.
15 Unlvered beta
16 Debt to Equity Ratio
17 Debt to Equity Beta
18 Cost of Equity
19 Debt to Ratio
Given
20 Equity Ratio
21 Revised WACC
22
Solution
30.00%
70.00%
6.00%
5.25%
1.20%
0.29
4.50%
35.00%
40%
arrow_forward
What is the inaccuracy under the RR column?
arrow_forward
Complete a and b thank you
arrow_forward
a. Perform a Du Pont analysis on Green Valley. Assume that the
industry average ratios are as follows:
Total margin
3.5%
Total asset turnover
1.5
Equity multiplier
2.5
Return on equity (ROE)
13.1%
b. Calculate and interpret the following ratios:
Industry Average
Return on assets (ROA)
Current ratio
5.2%
2.0
Days cash on hand
22 days
Average collection period
19 days
Debt ratio
71%
Debt-to-equity ratio
2.5
Times interest earned (TIE) ratio
2.6
Fixed asset turnover ratio
1.4
c. Assume that there are 10,000 shares of Green Valley's stock
outstanding and that some recently sold for $45 per share.
• What is the firm's price/earnings ratio?
What is its market/book ratio?
(Hint: These ratios are discussed in the supplement to this
chapter.)
arrow_forward
Requirement 1. Compute
these ratios:
Working
Capital
Current
Debt-to-
Ratio
Cash Ratio
Debt Ratio Equity Ratio
Round ratios to two
14.44
212400
7.73
decimal places or
format as percentages or
Accounts
Days Sales
currency as appropriate.
Inventory
Days Sales in
Gross ProfitReceivable
in
Turnover
Inventory
Percentage
Turnover
Receivables
2019 Total Assets =
Rate of
Rate of
Asset
Return on
Return on
Turnover
Stockholders'
Earnings
Total Assets
Ratio
Equity
Per Share
2019 SHE =
Price/
Earnings
*Current Stock Price is
Dividend
$10.00 per share
Ratio*
Dividend Yield
Payout
Dividend per share=
Requirement 2. Based on
the ratios computed above,
analyze the company's
ability to pay its debts (both
current and long term).
Refer to at least 3 specific
ratios in your analysis.
Requirement 3: Based on
the ratios computed above,
analyze the company's
management of inventory.
Refer to at least 2 specific
ratios in your analysis.
Requirement 4: Based on
the ratios computed above,
analyze the company's…
arrow_forward
Financial Plan
Components
Cost
Weights
Weighted Cost
A
Debt
7.15%
?
?
A
Equity
5.15%
55%
?
Weighted Average Cost of capital
FIND
B
Debt
9.90%
60%
?
B
Equity
11.50%
?
?
Weighted Average Cost of capital
FIND
C
Debt 150000
7.15%
?
?
C
Equity 450000
5.15%
?
?
Weighted Average Cost of capital
FIND
D
Debt 300000
7.15%
?
?
D
Equity 300000
5.15%
?
?
Weighted Average Cost of capital
FIND
Q1) Find Weighted Average capital for financial Plan C
Q2) Find Weighted Average capital for financial Plan D
Q3) Find Weighted Average capital for financial Plan A
Q4) Find Weighted Average capital for financial Plan B
arrow_forward
Calculate ‘Total Assets to Debt ratio’ from the following information :
Equity Share Capital 4,00,000
Long Term Borrowings 1,80,000
Surplus i.e. Balance in statement of Profit and Loss 1,00,000
General Reserve 70,000
Current Liabilities 30,000
Long Term Provisions 1,20,000
arrow_forward
Twenty metrics of liquidity solvency and profitability the comparative financial statements
arrow_forward
Example one
he information below has been extracted from the recently published accounts of Gabby Itd:
Extracts from the income statement to 3gn April 2016;
2015
Sales
Cost of sales
2016
(000)
11,200
(00)
9,750
6.825
8,460
Net profit before tax
465
320
The following expenses were charged
Depreciation
Loan note interest
Interest on bank overdraft
Audit fees
360
280
80
60
15
12
10
Tax
40
30
Balance sheet as at 30h April:
2016
2015
(000)
(000)
00)
(000)
Assets
Fixed assets
Current assets
Inventory
Receivables
1.850
1,430
640
490
1.080
120
1,230
Cash
80
1,950
3,800
1,690
3,120
Total assets
Equity and liabilities
Ordinary share capital
Retained earnings
800
800
1.310
2,110
930
1.730
18
arrow_forward
Provide this question solution general finance
arrow_forward
Calculate any 5 leverage ratios
arrow_forward
3. A 0.50 (50%) debt-equity ratio would suggest that a firm has:
a. 50% of its assets financed with debt
b. 33-1/3% of it assets financed with debt
c. an Equity Multiplier of 1.667
d. 66-23% of its assets financed with debt
arrow_forward
EXPLAIN THE RESULTS OF TOTAL LIABILITIES IN VERTICAL ANALYSIS
arrow_forward
Financial Accounting Question Solve Please
arrow_forward
Canvas
C. compute the earnings per share for the three financing packages by completing the table below:
Financial Package
3
Operating earnings in million
- interest expense in million
- Earnings available in million
No. of Shares
Earnings per share
d. complete the table below for each of the three financing packages based on three assumptions for the return on assets
shown below;
Financial Packages
Annual (ROA)
1 least leverage
3 most leverage
15%
10%
5%
F1
DII
F2
F3
F4
prt sc
arrow_forward
Question 1
The following information represent Mooncake Corporation
Details
Sales
Cash
Inventory
Current liabilities
Asset turnover
Current ratio
Debt to asset ratio
Receivables turnover
Calculate the following items:
a. Accounts receivables
b. Fixed asset
c. Long Term Debt
d. Debt to Asset Ratio
RM
3,549,000
179,000
911,000
788,000
1.40
2.95 times
40%
7 times
arrow_forward
Use the financial ratios of company A and company B to answer the questions below.
Company A Company B
Yr t+1 Year t Yr t+1 Year t
Current ratio 0.55 0.59 0.56 0.55
Accounts receivable turnover 6.22 6.25 5.06 4.87
Debt to total assets 40.5% 40% 67.8% 65.9%
Times interest earned 8.80 30.6 5.97 6.33
Free cash flows (in millions) ($3,819) $3,173 $168 $550
Return on stockholders’equity 7.7% 7.7% 26.6% 23.3%
Return on assets 4.3% 4.3% 8.9% 7.9%
Profit margin…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Related Questions
- Ratio Industry Ratios GnG Ratios 1. Current Ratio 5.3 7.08 2. Acid Test Ratio 5.1 6.8 3. Gross Profit Ratio 30% 40% 4. Net Income Margin 7.5% 18.2% 5. Receivable Turnover Ratio 9 14.41 6. Return on Asset Ratio 12% 9.29% 7. Debt to Asset Ratio 1:4 1 : 1 Interpretation and verbal analysis compared to industry ratios: 1. Liquidity 2. Profitability 3. Solvencyarrow_forwardIndustry Ratios Ratio GnG Ratios 1. Current Ratio 5.3 7.08 2. Acid Test Ratio 5.1 6.8 3. Gross Profit Ratio 30% 40% 4. Net Income Margin 7.5% 18.2% 5. Receivable Turnover Ratio 14.41 6. Return on Asset Ratio 12% 9.29% 7. Debt to Asset Ratio 1:4 LA 1 Interpretation and verbal analysis compared to industry ratios: Liquidity 1. 2. Profitability 3. Solvencyarrow_forwardData needed: SFP Asset section 1. Cash 16.3% 2. AR 6.3% 3. Short term investment 0.2% 4. Inventory 2.2% 5. Prepaid expenses 0.4% 6. PPE 74.7% Data needed: SFP Liabilities and OE section. 1. Current liab 16% 2. Non-current liab 34.2% 3. OE 49.9% Data needed: SCI 1. COGS 38.6% 2. Selling and admin exp 6.8% 3. Interest exp 0.1% 4. Income tax exp 0.5% 5. Net income 54%arrow_forward
- Calculate any 5 leverage ratioarrow_forwardGeneral Accounting Question Pls Need Answer with given optionarrow_forwardRatio Industry GnG Ratios Ratios 1. Net Income Margin 7.5% 18.2% 2. Receivable Turnover Ratio 9. 14.41 3. Return on Asset Ratio 12% 9.29% 4. Debt to Asset Ratio 1:4 1:1 Interpretation and verbal analysis compared to industry ratios: 1. Liquidity 2. Profitability 3. Solvencyarrow_forward
- 2. Calculate the financial leverage - equity multiplier and cash cover ratioarrow_forwardQ#2:Debt to Assets Ratio Debt to Equity Before-tax cost of debt0.0 0 6%0.1 0.11 7%0.2 0.25 9%0.3 0.43 12.5%0.4 0.66 15.5%Krf= 3%, Market Risk Premuim = 5%, T=30%, BUL = 0.9.Required: Determine, its capital structure. Q#3: A firm has 20 million shares outstanding, with a $30 per share market price. The firm has $10million in extra cash that it plans to use in a stock repurchase;…arrow_forwardQb 08.arrow_forward
- 1 2 Debt Ratio (current) 3 Equity Ratio (current) 4 Cost of Debt 5 Market Risk Premium 6 Equity Beta 7 Debt Beta 8 Risk Free Rate 9 Corporate Tax Rate 10 11 12 a. Cost of Equity 13 b. WACC 14 c. 15 Unlvered beta 16 Debt to Equity Ratio 17 Debt to Equity Beta 18 Cost of Equity 19 Debt to Ratio Given 20 Equity Ratio 21 Revised WACC 22 Solution 30.00% 70.00% 6.00% 5.25% 1.20% 0.29 4.50% 35.00% 40%arrow_forwardWhat is the inaccuracy under the RR column?arrow_forwardComplete a and b thank youarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning