I need to reconstruct the balance sheet with info given, and have no idea how to do this in reverse. Apparently the answers were posted on this site for someone else doing this assignment, but they still weren't exactly clear, and no explanation was given regarding how the answers were obtained. I want to know how to do the problem. Thanks.

Holyard Industries Assignment 2012 Financial Reports Selected Ratios Holyard Industries gathered the following financial information from its 2012 financial reports: Current Ratio Quick Ratio Inventory Inventory Turnover Expenses (ExcludingCOGS) Gross Margin Tax Rate $ $ 1.6 0.75 300,000 12 1,120,000 40% 34% Shares Outstanding Average Issue Price Stock Price TIE Ratio Interest Rate Fixed Asset Turnover Avg. Collection Period $ $ 290,000 5 18.37 8 8% 1.5 12 Complete the following financial statement templates by filling in the shaded areas and calculate the per share ratios: Balance Sheet Current Assets: Current Liabilities: Cash Accounts Receivable Inventory Total Current Assets Fixed Assets Current Liabilities Long-Term Liabilities (LT Debt) Total Liabilities Equity: Paid-In Capital Retained Earnings Total Equity Total Assets Liabilities and Equity Income Statement Revenue Cost of Goods Sold (COGS) Gross Margin (GM) Expenses Earnings Before Income and Tax (EBIT) Interest Earnings Before Tax Taxes Earnings After Tax (EAT) Book Value/Share Market to Book Ratio Current Ratio Quick Inventory T/O Stock Price TIE Ratio Fixed Asset T/O Avg. Collection Book Value/Sh. Market to Book Competitors Industry 1.6 1.4 0.8 0.125 11.5 13 19.25 18.25 7.5 8.25 1.65 1.45 12.25 11.75 7.75 7.32 3.12 2.54 Holyard Industries Assignment 2012 Financial Reports Selected Ratios Holyard Industries gathered the following financial information from its 2012 financial reports: Current Ratio Quick Ratio Inventory Inventory Turnover Expenses (ExcludingCOGS) Gross Margin Tax Rate $ $ 1.6 0.75 300,000 12 1,120,000 40% 34% Shares Outstanding Average Issue Price Stock Price TIE Ratio Interest Rate Fixed Asset Turnover Avg. Collection Period $ $ 290,000 5 18.37 8 8% 1.5 12 Complete the following financial statement templates by filling in the shaded areas and calculate the per share ratios: Balance Sheet Current Assets: Current Liabilities: Cash Accounts Receivable Inventory Total Current Assets Fixed Assets 64,706 200,000 300,000 564,706 4,000,000 Current Liabilities Long-Term Liabilities (LT Debt) Total Liabilities Equity: Paid-In Capital Retained Earnings Total Equity Total Assets 352,941 2,000,000 2,352,941 4,564,706 Liabilities and Equity 1,450,000 761,765 2,211,765 4,564,706 Income Statement Revenue Cost of Goods Sold (COGS) Gross Margin (GM) Expenses Earnings Before Income and Tax (EBIT) Interest Earnings Before Tax Taxes Earnings After Tax (EAT) 6,000,000 Book Value/Share 3,600,000 Market to Book Ratio 2,400,000 1,120,000 1,280,000 160,000 1,120,000 380,800 739,200 $ 7.63 2.41 Explanation GoGs = 300000*12 GP margin is 0.4 therefore COGS is 1-.4 = 0.6 Sales = COGS/0.6 Interest = Operating income/8 Taxes = EBT*0.4 All other workings in income statemen may be viewed when you click on the respective cell of the figure Current ratio-quick ratio = 1.6-.75 = 0.85 Current Liabilities = 300000/0.85 Account Receivables = sales/360*12 Total Current assets = Current liabilities *1.6 Cash is the difference of Total Current Assets-Account Receivables-Inventory Fixed Assets = Sales/1.5 Long Term Debt = Interest expense/.08 (interest rate) Paid In capital = outstanding shares x average issue price Retained earnings is the difference of total assets less total liabilities less paid in capital All other calcuations in balance sheet may be viewed by clicking on the respectiv cell of the figure. Current Ratio Quick Inventory T/O Stock Price TIE Ratio Fixed Asset T/O Avg. Collection Book Value/Sh. Market to Book Competitors 1.6 0.8 11.5 19.25 7.5 1.65 12.25 7.75 3.12 Industry 1.4 0.125 13 18.25 8.25 1.45 11.75 7.32 2.54 Holyard Industries Assignment 2012 Financial Reports Selected Ratios Holyard Industries gathered the following financial information from its 2012 financial reports: Current Ratio Quick Ratio Inventory Inventory Turnover Expenses (ExcludingCOGS) Gross Margin Tax Rate $ $ 1.6 0.75 300,000 12 1,120,000 40% 34% Shares Outstanding Average Issue Price Stock Price TIE Ratio Interest Rate Fixed Asset Turnover Avg. Collection Period $ $ 290,000 5 18.37 8 8% 1.5 12 Complete the following financial statement templates by filling in the shaded areas and calculate the per share ratios: Balance Sheet Current Assets: Current Liabilities: Cash Accounts Receivable Inventory Total Current Assets Fixed Assets 64,706 200,000 300,000 564,706 4,000,000 Current Liabilities Long-Term Liabilities (LT Debt) Total Liabilities Equity: Paid-In Capital Retained Earnings Total Equity Total Assets 352,941 2,000,000 2,352,941 4,564,706 Liabilities and Equity 1,450,000 761,765 2,211,765 4,564,706 Income Statement Revenue Cost of Goods Sold (COGS) Gross Margin (GM) Expenses Earnings Before Income and Tax (EBIT) Interest Earnings Before Tax Taxes Earnings After Tax (EAT) 6,000,000 Book Value/Share 3,600,000 Market to Book Ratio 2,400,000 1,120,000 1,280,000 160,000 1,120,000 380,800 739,200 $ 7.63 2.41 Explanation GoGs = 300000*12 GP margin is 0.4 therefore COGS is 1-.4 = 0.6 Sales = COGS/0.6 Interest = Operating income/8 Taxes = EBT*0.4 All other workings in income statemen may be viewed when you click on the respective cell of the figure Current ratio-quick ratio = 1.6-.75 = 0.85 Current Liabilities = 300000/0.85 Account Receivables = sales/360*12 Total Current assets = Current liabilities *1.6 Cash is the difference of Total Current Assets-Account Receivables-Inventory Fixed Assets = Sales/1.5 Long Term Debt = Interest expense/.08 (interest rate) Paid In capital = outstanding shares x average issue price Retained earnings is the difference of total assets less total liabilities less paid in capital All other calcuations in balance sheet may be viewed by clicking on the respectiv cell of the figure. Current Ratio Quick Inventory T/O Stock Price TIE Ratio Fixed Asset T/O Avg. Collection Book Value/Sh. Market to Book Competitors 1.6 0.8 11.5 19.25 7.5 1.65 12.25 7.75 3.12 Industry 1.4 0.125 13 18.25 8.25 1.45 11.75 7.32 2.54