Answersheet-week2KarishmaSagar2.xlsx

Answersheet-week2KarishmaSagar2.xlsx

Red Company Homework

Enter your answers below – numbers only with
20172016
EX2-1% of net sales% of net sales
1Cost of Sales63.20%63.40%
2Gross profit36.70%36.50%
3selling, general, and admin expense22.50%22.50%
4operating earnings14.17%13.97%
5net earnings10.60%9.65%
B.Discuss which line item (Cost of sales or selling, general and administrative expense) helped to increase the operating earnings and net earnings as a % of Net Sales from 2016 to 2017This helped operating earnings and net earnings as a percent of sales go up from 2016 to 2017, because the cost of sales was a little less in 2017. This helped.
20172016
EX 2-2% of net sales% of net sales
1Total receivables, net12.25%11.79%
2Inventories, net22%22.17%
3Accounts payable14.17%13.61%
4Retained earnings7.50%7.88%
5Total stockholders' equity41.31%39.72%
B.Did liabilities or equity finance more of Toro's Total assets in 2017?liabilities
20172016
EX-2-3% of net sales% of net sales
1Net sales4.72%0.05%
2Cost of sales4.21%2.40%
3Gross profit5.28%4.69%
4selling, general, and admin expense4.72%0.62%
5net earnings18.89%14.58%
B.Coment on the percent change in gross profit from 2016 to 2017 compared to the percent change in net sales from 2016 to 2017It is the percentage change in net sales from 2016 to 2017. Even though net sales have gone up a lot from last year compared to gross profit.
20172016
EX2-4% of net sales% of net sales
1Total receivables, net$19,80812.13%
2Inventories, net$21,9587.15%
3Accounts payable$37,08421.23%
4Retained Earnings$54,28511.30%
B.Comment on the percent change in inventory from 2016 to 2017 compared to the percent change in cost of sales from 2016 to 2017When you compare the percentage changes in inventory from 2016 to 2017 to the percentage changes in cost of sales from 2016 to 2017, you see that inventory changed more than cost of sales changed.

Internet Exercise

Big RockCandy Mountain Mining Co.
Income Statement
For the Year Ended Dec. 31,2020
20202019
Sales412,500398,600
Cost of Goods Sold318,786315,300
Gross Profit93,71483,300=B5-B6
Selling and G&A Expenses26,25024,550
Other Expenses1,2101,245
Depreciation Expense29,80029,652
EBIT36,45427,853=B7-SUM(B8:B10)
Interest Expense8,5828,457
Earnings Before Taxes27,87219,396=B11-B12
Taxes6,9684,849=B13*B18
Netlncome20,90414,547=B13-B14
Notes:
Tax Rate0.250.25
Shares52,10052,100
EPS$0.40$0.40
Big Rock Candy Mountain Mining Co.
Balance Sheet
As of Dec. 31,2020
Assets20202019
Cash16,43511,596
Accounts Receivable45,89647,404
Marketable Securities3,656619
Inventory52,39754,599
Total Current Assets118,384114,218=SUM(B5:B8)
Gross Fixed Assets436,573397,023
Accumulated Depreciation87,45057,650
Net Plant & Equipment349,123339,373=B10-B11
Total Assets467,507453,591=B9+B12
Liabilities and Owner's Equity
Accounts Payable37,75236,819
Accured Expenses3,1833,085
Total Current Liabilities40,93539,904=SUM(B15:B16)
Long-term Debt170,562178,581
Total Liabilities211,497218,485=B17+B18
Common Stock58,66458,664
Additional Paid-In-Capital136,807136,807
Retained Earnings60,53939,635
Total Shareholder's Equity256,010235,106=SUM(B20:B22)
Total Liabilities and Owner's Equity467,507453,591=B19+B23
Big Rock Candy Mountain Mining Co.
Common Size Income Statement
For the years 2019 and 2020
Income StatementCommon Size Income Statement
2020201920202019
Sales412,500.00398,600.00100.00%100.00%
Cost of Goods318,786.00315,300.0077.28%79.10%
Gross Profit93,714.0083,300.0022.72%20.90%
Depreciation29,800.0029,652.007.22%7.44%
Selling & Admin. Expense26,250.0024,550.006.36%6.16%
Other Operating Expense ___1,210.001,245.000.29%0.31%
Net Operating Income36,454.0027,853.008.84%6.99%
Interest Expense8,582.008,457.002.08%2.12%
Earnings Before Taxes27,872.0019,396.006.76%4.87%
Taxes6,968.004,849.001.69%1.22%
Net Income20,904.0014,547.005.07%3.65%
New Smyrna Surf Shop
Statement of Cash Flows
For the Year 2020
Cash Flows from Operations
Net Income120.540.00
Depreciation Expense7,148
Change in Accounts Receivable(11,248)
Change in Inventories(8,276)
Change in Accounts Payable1,589
Total Cash Flows from Operations109,753.00
Cash Flows from Investing
Change in fixed assets(41,704)
Total Cash Flows from InvestingS (41,704)
Cash Flows from Financing
Change in Notes Payable(3,025)
Change in Long-Term Debt755
Change in Common Stock
Change in Paid-In Capital
Cash Dividends(60,000)
Total Cash Flows from Financing(62,270.00)
Net Change in Cash Balance5,779.00
Check answer against Balance Sheet
Beginning Cash From Balance Sheet15,187
Ending Cash From Balance Sheet20,966
Net Change in Cash Balance5,779.00