Take the following information on a company and prepare its balance sheet. a. The company has gross sales of $400 thousand per month and the pattern of sales is even, i.e. there is no cyclical pattern to sales. b.COGS for the business is 50% and is 75% materials c. There is enough raw material on hand to support 3 months of manufacturing, and there are enough finished goods in the warehouse to accommodate 2 month of orders d.For simplicity, assume we have no work in progress e. The company pays its suppliers 2 month after goods are received 1. Customers are large firms, which pay us 2 months after we deliver our product. The owners started the business with an initial capital injection of $1.5 million and a $500 thousand long-term bank loan, just over 5 years ago h. The bank loan principle is payable in 10 equal annual payments, and the 5th annual payment has recently been made in the first 5 years of the business, the company had a cumulative net income of $1.5 milion, and paid dividends of $250 thousand for the first time this past year Monthly payrol is $200 thousand, paid monthly. We're currently 50% through the current pay cycle. K. All utilities and those types of bills have just recently been paid 1. The company bought 52 million in assets at startup and picked a straightline depreciation period of 20 years. No additional assets have been purchased m. The business has 5500 thousand in cash on hand and a short-term credit line that is paid down andlor drawn from based on the fluctuations of the business n. There are no short-term or long-term investments, no prepaid expenses, no goodwill, and no repayable grants, and taxes are up to date. Notes: 1. Use the information provided in the problem statement to assign the quantities for the various accounts in the balance sheet below. 2. Calculate the required quantities to indicate the correct amount on each of blanks in the balance sheet for those accounts 3. Express your quantities in your answer in thousands (5000). 4. If needed, round your answer to 2 decimal places Notes: 1. Use the information provided in the problem statement to assign the quantities for the various accounts in the balance sheet below. 2. Calculate the required quantities to indicate the correct amount on each of blanks in the balance sheet for those accounts. 3. Express your quantities in your answer in thousands (5000). 4. If needed, round your answer to 2 decimal places. Balance Sheet - $(000) Liabilities Current Assets Current Liabilities: Cash e.g. 500 Short-Term Credit Line Assets Receivables Short-Term Investments Accounts Payable Accrued Expenses Inventory Taxes Payable Current Portion Long-Term Debt Prepaid Expenses Fixed Assets Land, Bid &Equip Cost Less Accumulated Depreciation Sum of the Current Liability Long Term Liabilities Repayable Grants Long-Term Debt Total Fixed Assets Shareholders Equity Capital Shares Long-Term investments Goodwill Retained Earning Total Liabilities And Equity Total Assets Take the following information on a company and prepare its balance sheet. a. The company has gross sales of $400 thousand per month and the pattern of sales is even, i.e. there is no cyclical pattern to sales. b.COGS for the business is 50% and is 75% materials c. There is enough raw material on hand to support 3 months of manufacturing, and there are enough finished goods in the warehouse to accommodate 2 month of orders d.For simplicity, assume we have no work in progress e. The company pays its suppliers 2 month after goods are received 1. Customers are large firms, which pay us 2 months after we deliver our product. The owners started the business with an initial capital injection of $1.5 million and a $500 thousand long-term bank loan, just over 5 years ago h. The bank loan principle is payable in 10 equal annual payments, and the 5th annual payment has recently been made in the first 5 years of the business, the company had a cumulative net income of $1.5 milion, and paid dividends of $250 thousand for the first time this past year Monthly payrol is $200 thousand, paid monthly. We're currently 50% through the current pay cycle. K. All utilities and those types of bills have just recently been paid 1. The company bought 52 million in assets at startup and picked a straightline depreciation period of 20 years. No additional assets have been purchased m. The business has 5500 thousand in cash on hand and a short-term credit line that is paid down andlor drawn from based on the fluctuations of the business n. There are no short-term or long-term investments, no prepaid expenses, no goodwill, and no repayable grants, and taxes are up to date. Notes: 1. Use the information provided in the problem statement to assign the quantities for the various accounts in the balance sheet below. 2. Calculate the required quantities to indicate the correct amount on each of blanks in the balance sheet for those accounts 3. Express your quantities in your answer in thousands (5000). 4. If needed, round your answer to 2 decimal places Notes: 1. Use the information provided in the problem statement to assign the quantities for the various accounts in the balance sheet below. 2. Calculate the required quantities to indicate the correct amount on each of blanks in the balance sheet for those accounts. 3. Express your quantities in your answer in thousands (5000). 4. If needed, round your answer to 2 decimal places. Balance Sheet - $(000) Liabilities Current Assets Current Liabilities: Cash e.g. 500 Short-Term Credit Line Assets Receivables Short-Term Investments Accounts Payable Accrued Expenses Inventory Taxes Payable Current Portion Long-Term Debt Prepaid Expenses Fixed Assets Land, Bid &Equip Cost Less Accumulated Depreciation Sum of the Current Liability Long Term Liabilities Repayable Grants Long-Term Debt Total Fixed Assets Shareholders Equity Capital Shares Long-Term investments Goodwill Retained Earning Total Liabilities And Equity Total Assets