B&L Landscapes, Inc. Mini Practice Part 3 Bill Graham and Larry Miller incorpora
ID: 2548151 • Letter: B
Question
B&L Landscapes, Inc. Mini Practice Part 3
Bill Graham and Larry Miller incorporated B&L Landscapes, Inc. on July 1, 2014. The business consists of lawn care and sprinkler system installations. In addition, they also sell two types of fertilizer. At the end of the first year, Bill and Larry have asked you to analyze their first year of operations and given them some suggestions on areas that may need improvement as they move into their second year. Below are the balance sheets for the date of incorporation and the end of the first year of operations.
B&L Landscapes, Inc.
Balance Sheet
July 1, 2014
Assets
Current Assets
Cash $27,500
Accounts Receivable (net) 3,500
Prepaid Insurance 1,500
Inventory 6,000
Total Current Assets $38,500
Property, Plant and Equipment
Land 8,000
Building 25,000
Equipment 18,500
51,500
Total Assets $90,000
Liabilities and Stockholders’ Equity Current Liabilities
Accounts Payable $10,000
Long-Term Liabilities Notes Payable 45,000
Total Liabilities $55,000
Stockholders’ Equity Paid-in Capital
Capital Stock( 5% Preferred stock, $100 par value, non-cumulative, non-participating, 5,000 shares authorized, 50 shares issued and outstanding 5,000 Common stock, $1 par value, 150,000 shares authorized, 30,000 shares issued and outstanding) 30,000
Total Capital Stock 35,000
Retained Earnings 0
Total Stockholders’ Equity 35,000
Total Liabilities and Stockholders’ Equity $90,000
B&L Landscapes, Inc.
Balance Sheet
June 30, 2015
Assets
Current Assets
Cash $23,850
Accounts Receivable (net) 6,275
Prepaid Insurance 1,500
Inventory 29,125
Total Current Assets $60,750
Property, Plant and Equipment
Land 8,000
Building 25,000
Less Accumulated Depreciation 1,250 23,750
Equipment 32,500
Less Accumulated Depreciation 7,000 25,500 57,250
Total Assets $118,000
Liabilities and Stockholders’ Equity Current Liabilities
Accounts Payable $17,500
Long Term Liabilities
Notes Payable 45,000
Total Liabilities $62,500
Stockholders’ Equity Paid in Capital
Capital Stock (5% Preferred stock, $100 par value, non-cumulative, non- participating, 5,000 shares authorized, 70 shares issued and outstanding 5,000 Common stock, $1 par value, 150,000 shares authorized, 40,000 shares issued and outstanding) 30,000
Total Capital Stock 35,000
Retained Earnings 20,500
Total Stockholders’ Equity 55,500
Total Liabilities and Stockholders’ Equity$118,000
Additional Information:Net Income for the year ending June 30, 2015 was $22,500 and $2,000 was paid in dividends. Net Sales for the year ending June 30, 2015 was $201,000.
Industry Averages-Landscaping Services
Assets
Current Assents 45%
Plant Assets (net) 55%
Total Assets 100%
Liabilities
Current Liabilities 18%
Long-Term Liabilities 15%
Total Liabilities 33%
Stockholder's Equity
Common Stock, $1 par 10%
Prefferred Stock, $100 par 20%
Retained Earnings 37%
Total Stockholder's equity 67%
Total Liabilities and Stockholders' equity 100%
Instructions:
1. Using the two balance sheets provided, prepare a horizontal and vertical analysis for the period ending June 30, 2015. You only need to complete one vertical analysis using the June 30, 2015 balance sheet values.
2. Compare the vertical analysis results with the industry average information provided and identify any areas that you believe merit further investigation, including why you would investigate them further and likely reasons for the results.
3. Calculate the following ratios for the company: 1) Current Ratio 2) Acid-test ratio 3) Profit Margin 4) Asset Turnover 5) Return on Assets 6) Debt to Assets Ratio
Data Entry Tools:
Horizontal Analysis
B&L LANDSCAPES, INC
CONDENSED BALANCE SHEETS
FOR THE YEAR ENDING JUNE 30
Vertical Analysis
B&L LANDSCAPES, INC
CONDENSED BALANCE SHEETS
FOR THE YEAR ENDING JUNE 30
RATIOS
Current Ratio-
Acid Test Ratio-
Profit Margin-
Asset Turnover-
Return on Assets-
Debt to Assets Ratio-
2015 2014 increae or amount (decrease) Percent Assets Liabilities Stockholders' EquityExplanation / Answer
1. Vertical Analysis
B&L Landscapes, Inc.
Condensed Balance Sheet
for the year ending June 30, 2015
2015
Industry Averages
Amount
Percent
Percent
Variance
Assets
Current Assets
Cash
$23,850
20.21%
Account Rec.
$6,275
5.32%
Prepaid Insurance
$1,500
1.27%
Inventory
$29,125
24.68%
Total Current Assets
$60,750
51.48%
45%
6.48%
Property, Plant and Equipment
Land
$8,000
6.78%
Building $25,000
Less:Accu. Dep. $1,250
$23,750
20.13%
Equipment $32,500
Less:Accu. Dep. $7,000
$25,500
21.61%
Total Plant Property and Equip.
$57,500
48.73%
55%
6.27%
Total Assets
$118,000
100%
100%
0%
Liability & Stockholders' equity
Current Liability
Account Payable
$17,500
14.83%
18%
3.17%
Long-Term Liabilities
Notes Payable
$45,000
38.14%
15%
23.14%
Total Liabilties
$62,500
52.97%
33%
19.97%
Shareholders' Equity
Common stock
$30,000
25.42%
10%
15.42%
Preferred stock
$5,000
4.24%
20%
15.76%
Retained Earning
$20,500
17.37%
37%
19.63%
Total Stockholders' Equity
$55,500
47.03%
67%
19.97%
Total Liabilities and Stockholders' Equity
$118,000
100%
100%
0%
2.) Total Current assets and Noncurrent assets need further investigation because current industrial variance do no show the composition of both the types of assets.
3.) Ratios
a) Current Ratio = Current Assets / Current Liabilities
= $60,750 / $17,500 = 3.47 : 1
b) Acid Test Ratio = (Current assets – Inventory - Prepaid Expense) / Current Liabilities
= ($60,750 - $29125 - $1,500) / $17,500 = 1.72 : 1
c) Profit Margin = Net Income / Net Sales
= $22,500 / $201,000 = 0.1119 or 11.19%
d) Asset Turnover Ratio = Sales / Total Assets
= $201,000 / $118,000 = 1.70 times
e) Return on Assets = Net Income / Total Assets
= $22,500 / $118,000 = 19.07%
f) Debt to Assets Ratio = Total Liabilities / Total Assets
= $62,500 / $118,000 = 0.53
B&L Landscapes, Inc.
Condensed Balance Sheet
for the year ending June 30, 2015
2015
Industry Averages
Amount
Percent
Percent
Variance
Assets
Current Assets
Cash
$23,850
20.21%
Account Rec.
$6,275
5.32%
Prepaid Insurance
$1,500
1.27%
Inventory
$29,125
24.68%
Total Current Assets
$60,750
51.48%
45%
6.48%
Property, Plant and Equipment
Land
$8,000
6.78%
Building $25,000
Less:Accu. Dep. $1,250
$23,750
20.13%
Equipment $32,500
Less:Accu. Dep. $7,000
$25,500
21.61%
Total Plant Property and Equip.
$57,500
48.73%
55%
6.27%
Total Assets
$118,000
100%
100%
0%
Liability & Stockholders' equity
Current Liability
Account Payable
$17,500
14.83%
18%
3.17%
Long-Term Liabilities
Notes Payable
$45,000
38.14%
15%
23.14%
Total Liabilties
$62,500
52.97%
33%
19.97%
Shareholders' Equity
Common stock
$30,000
25.42%
10%
15.42%
Preferred stock
$5,000
4.24%
20%
15.76%
Retained Earning
$20,500
17.37%
37%
19.63%
Total Stockholders' Equity
$55,500
47.03%
67%
19.97%
Total Liabilities and Stockholders' Equity
$118,000
100%
100%
0%
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.