Question

Uncle Ernie's Lumber Emporium Read the following scenario and complete the financial statements and calculate the appropriate financial ratios I have attached a file containing an Excel spreadsheet for your convenience Part-1 Your uncle Ernie just passed away and left you his lumber yard. The will says that you must operate the lumberyard for at least five years after his death; after the five year period you can sell it or continue to operate it. Going through last year's records you notice that the lumberyard had cash sales of $130,000 and credit card sales of $ 1 22,448.98 (for credit card sales you have to pay 2% to the credit card company-this would be a cost of goods sold). Uncle Emie's lumberyard also received $250,000 in account sales the lumberyard offers a 10% discount for account customers who pay within 10 days of recen!ng the bill and all customers took advantage of the discount (the discount is a cost of goods sold). The lumber supplier sent Uncle Ernie mismarked lumber, causing the lumberyard to have $20,000 in customer returns and S3000 in markdowns. The lumberyard paid a total of $200,000 for the merchandise and $25,000 for shipping to obtain goods for sale (this type of shipping is part of cost of goods sold). Last year uncle Emie paid himself a salary of $1,250 per month and paid his employees a salary of $110,000; in addition he paid $4,950 for advertising, S1250 for supplies S1,500 for miscellaneous shipping, $4,500 for insurance, $5,000 for maintenance, and $2,500 to lease computers and cash registers. (Note: assume a 24% tax rate-multiply the NPBT by the tax rate) From this information, create a profit and loss statement and indicate what uncle Ernie made last year (round answers to the nearest S1). ncome Net Sales Cost of Goods Sold Gross Profit Operating Expenses Salaries Advertising Supplies Shipping nsurance Maintenance Leased Equipment Total Net profit before taxes Taxes Net profit after taxes Part-2 Uncle Ernie's forgetful accountant, Billy Bailey gave you the following balance sheet complete the parts that Billy Bailey left-out (i.e., determine the total assets, tota abilties, owner's equity, and liabilities &net worth) Assets Current Liabilities Current Payroll Taxes Accounts Payable Short-term Loan $12,000 15,000 40,000 Cash $25,000 133,500 52,000 $210,500 Accounts receivable Total Total $68,050 Fixed Fixed Property Building Store fixtures Equipment 225,000 300,000 14,550 2,550 $542,100 Mortgage Long-term loan 175,000 5,000 $260,000 Total Total Total Liabilities Total assets Owner's Equity Liabilities & Net worth Part-3 Using the P& L statement and the balance sheet to calculate the quick ratio, current ratio, net profit margin, asset turnover, retun on assets, financial leverage, and return on net worth to determine whether Uncle Emie's lumber yard is running efficiently

Answer 1

Profit and Locs State memd Income Amt in (3) Net Sale Cest of Goods Sold Grass profit 48344 361837 0061マ Advetiing Suppl ies shipping Insorance Mairtenance Lease equipmont 49 50 250 1500 千500 ˋ夏000 a500 139700 Total Net Profit botoue tcU10亼 Tarte 9022 Net Peoit alts tones des)

wokin 130,000 Credit card SoOos -$ (39449 +8944 Griven in nao 14 is 50 00 况0,000 85), on ales Naouk up on rot soos $4824 49χ45x Costat Teds cold = 4g8 447-旧061& Discoont on credit card Salas → 4139449 x & y. Discount t account sabo』 づマ50,000 x10% キマ5000 Since discount on CY account d iven as a poortb cost of goeds Sold, thoy we a) Sinco CoGS s given as a pentage, all Costs asre includad init

otak α.sela --F·OID 500+ 4 54ョ100 = 759600 -$ Ocore圸equity 144 8638 3マ8050 44550 Net rth4SSo 9028 loss 448638 Casht Ace. Rocevi Cument liaunditio Quick vatio 1.13 Cument vatio 31050 68。50 = 3.OT Net ofit 1088) ( 1.88) 六

Net Sala 48 2449 75 600 O-64 (9083) Asset t の 647. ketun on asset financied laverag Del-t Equity 44863 .14 By calculatong all the veci es, the balance shet pasition Profts, the vatios uwile shour positive csmpany is in losse亼. pocition is god to lombost ya9td, but it it can eam eruet Lumlr yaord shauld try to ct indivect Cost tran cao, to increase profits.