1. Lilly Company expects its Sales in January to be $120,000 and expects Sales to grow...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Lilly Company expects its Sales in January to be $120,000 and expects Sales to grow by 10% each month. 2. All sales are on credit and it collects 60% of all sales in the month of the sale, the remaining 40% in the month after the sale. 3. The cost of goods sold is equal to 70% of sales. 4. Lilly Company likes to keep an ending inventory equal to 20% of next months cost of goods sold on hand. 5. All purchases of inventory are on account, and the company pays for 80% of all purchases in the month of the purchase, 20% in the month after the purchase. 6. The company pays its sales force a commission equal to 6% of sales. 7. The company also believes that its supplies expense is equal to $5,000 plus 1% of sales. 8. Rent is $4,000 per month, Advertising is $3,000 per month, Depreciation is $3,000 per month, and Utilities are $2,500 per month. 9. The company purchased an insurance policy covering 24 months for $24,000 on January 1. 10. All selling and administrative expenses are paid in the month they are incurred except for commissions that are paid in the month after they are earned and the insurance which is paid two years in advance. 11. On January 31, Lily Company purchased Land costing $38,000. Lily paid cash for the land. 12. Interest on long-term debt is equal to 1% of the beginning balance and is paid each month. The company must maintain a minimum balance in cash of S10,000 and will use any cash surplus to pay down long-term debt. The company borrows cash in S1.000 increments. 13. The company is subject to a 25% income tax rate. The company pays income taxes in the month after they are accrued (expensed). 14. In January, the company will declare a $2,500 dividend that it will pay in February. 15. The company had a beginning balance sheet (as of January 1) as follows: ASSETS: LIAB & STOCKHOLDERS EQUITY Current Assets Current Liabilities Cash $10.000 Accounts Payable Commissions Payable Income Taxes Payable Dividends Payable $15.680 Accounts Receivable $44.000 $6.600 Prepaid Insurance $1.000 Inventory $16.800 $-0 Total Currents Assets $70,000 Total Current Liabilities Long Term Debt Stockholders Equity Common Stodk $23,200 Property, Plant, & Equipment $60,000 Land $10.000 Equipment $40.000 $10,000 Accumulated Depreciation $20.000) $30,000 Retained Earnings Total Stockholders Equity $7.520 Total PPE $17,520 Total Assets $100,800 Total liab & SE $100,00 Prepare for January and February: 1. Sales budget 2. Purchases budget 3. Selling & Admin Expense budget 4. Cash Budget 5. Budget/Proforma Income Statement 6. Budget/Proforma Balance Sheet 1. Lilly Company expects its Sales in January to be $120,000 and expects Sales to grow by 10% each month. 2. All sales are on credit and it collects 60% of all sales in the month of the sale, the remaining 40% in the month after the sale. 3. The cost of goods sold is equal to 70% of sales. 4. Lilly Company likes to keep an ending inventory equal to 20% of next months cost of goods sold on hand. 5. All purchases of inventory are on account, and the company pays for 80% of all purchases in the month of the purchase, 20% in the month after the purchase. 6. The company pays its sales force a commission equal to 6% of sales. 7. The company also believes that its supplies expense is equal to $5,000 plus 1% of sales. 8. Rent is $4,000 per month, Advertising is $3,000 per month, Depreciation is $3,000 per month, and Utilities are $2,500 per month. 9. The company purchased an insurance policy covering 24 months for $24,000 on January 1. 10. All selling and administrative expenses are paid in the month they are incurred except for commissions that are paid in the month after they are earned and the insurance which is paid two years in advance. 11. On January 31, Lily Company purchased Land costing $38,000. Lily paid cash for the land. 12. Interest on long-term debt is equal to 1% of the beginning balance and is paid each month. The company must maintain a minimum balance in cash of S10,000 and will use any cash surplus to pay down long-term debt. The company borrows cash in S1.000 increments. 13. The company is subject to a 25% income tax rate. The company pays income taxes in the month after they are accrued (expensed). 14. In January, the company will declare a $2,500 dividend that it will pay in February. 15. The company had a beginning balance sheet (as of January 1) as follows: ASSETS: LIAB & STOCKHOLDERS EQUITY Current Assets Current Liabilities Cash $10.000 Accounts Payable Commissions Payable Income Taxes Payable Dividends Payable $15.680 Accounts Receivable $44.000 $6.600 Prepaid Insurance $1.000 Inventory $16.800 $-0 Total Currents Assets $70,000 Total Current Liabilities Long Term Debt Stockholders Equity Common Stodk $23,200 Property, Plant, & Equipment $60,000 Land $10.000 Equipment $40.000 $10,000 Accumulated Depreciation $20.000) $30,000 Retained Earnings Total Stockholders Equity $7.520 Total PPE $17,520 Total Assets $100,800 Total liab & SE $100,00 Prepare for January and February: 1. Sales budget 2. Purchases budget 3. Selling & Admin Expense budget 4. Cash Budget 5. Budget/Proforma Income Statement 6. Budget/Proforma Balance Sheet
Expert Answer:
Related Book For
Financial Management Principles and Applications
ISBN: 978-0134417219
13th edition
Authors: Sheridan Titman, Arthur J. Keown, John H. Martin
Posted Date:
Students also viewed these accounting questions
-
Which language consists of numbers (ultimately reduced to 1s and Os)? a. High Level b. Machine O c. Assembly O d. C
-
Sales revenue less cost of goods sold is called net profit. A. True B. False
-
Cost of Goods Sold is reported as an asset on the balance sheet. as a direct reduction of equity on the statement of changes in stockholders\' equity. as an addition to Sales Revenue on the income...
-
Describe three ways in which a gradual increase in an extracellular signal can be sharpened by the target cell to produce an abrupt or nearly all-or none response.
-
What is the current account balance in the question 2?
-
After estimating the model \(y=\beta_{1}+\beta_{2} x_{2}+\beta_{3} x_{3}+e\) with \(N=203\) observations, we obtain the following information: \(\sum_{i=1}^{N}\left(x_{i 2}-\bar{x}_{2}...
-
A safety PLC has been certified to IEC 62443-4-1 and IEC 62443-4-2. Is this device guaranteed to be hacker proof?
-
Komissarov Company has a debt investment in the bonds issued by Keune Inc. The bonds were purchased at par for $400,000 and, at the end of 2012, have a remaining life of 3 years with annual interest...
-
On January 1, 2025, the Ivanhoe Company general ledger shows Equipment $38,000 and Accumulated Depreciation $13,840. The depreciation resulted from using the straight-line method with a useful life...
-
Lang and Thomas, a local CPA firm, has been asked to bid on a contract to perform audits for three counties in its home state. Should the firm be awarded the contract, it must hire one new staff...
-
Ingrid is considering of buying an insurance today. Insurance A will pay $150,000 starting next year, and for the first five years the annual payments would increase by 2% each year. Thereafter she...
-
Summarize your conclusions about how amenities affect incomes and real-estate prices. Although some conclusions are ambiguous, it is possible to offer a clear-cut statement when the effect of...
-
What techniques can be used to ensure clarity and avoid ambiguity in memo writing? Discuss the importance of clear directives and the potential consequences of misinterpretation.
-
What are the key mechanisms by which mitochondria maintain the mitochondrial membrane potential, and how does the disruption of this potential affect ATP synthesis and cellular energetics ?
-
Mary Ann purchased a second-hand Subaru from Unfriendly Motors Ltd., a used car dealership, under a conditional sale agreement. Mary Ann used the car for several months and made her payments...
-
What makes a good leader? what makes a bad leader?, what leadership styles be?, how does leadership affects a workplace? how does it affects communication? What is the intended outcome of the...
-
Find the Computation of Taxable Income and expand Deductions for Individuals and Corporations. Provide the number and title of any recent development (marked with image.png) under Trade or business...
-
Explain five different cases of income exempt from tax with clear examples.
-
The stock price of Perkiman Go Inc. is currently $40 a share. If the firm announces a 10 percent stock dividend, what do you expect the ex-dividend stock price to be? What about a 20 percent stock...
-
What are the markets and mechanics involved in engaging in simple arbitrage?
-
What is the significance of the notion that a firm's financing decisions are irrelevant? What does this mean to the financial manager?
-
Maribel Ortiz is puzzled. Her company had a profit margin of 10% in 2025. She feels that this is an indication that the company is doing well. Gordon Liddy, her accountant, says that more information...
-
At December 31, 2025, the fair value of non-trading securities is 41,300 and the cost is 39,800. At January 1, 2025, there was a credit balance of 900 in the Fair Value Adjustment Non-Trading...
-
On January 1, 2025, Lennon Enterprises acquires 100% of Ono Ltd. for 220,000 in cash. The condensed statements of financial position of the two companies immediately following the acquisition are as...
Study smarter with the SolutionInn App