In: Finance
Q.1. A ) ALEX’s BAXTER Corporation (ABC) is in its first year of operations. Using the information below, prepare a year-end income statement and balance sheet for the business (Remember to increase/reduce equity by the amount of income/loss).
1. Through 2020, ABC purchased 5,000 bandanas at an average cost of $2 per bandana. ALEX marked-up her bandanas to 2.5 times purchase price and sold all items in the same year. On December 31st, Alex had $5,950 cash in her corporate bank account and no remaining inventory, so she ordered 2,000 bandanas at a cost of $2.10 each (they were delivered to her the same day and she paid cash).
2. Alex is paid a monthly salary of $1,000 from ABC. Also, she rents a sales booth on weekends, so she can sell bandanas in person (in addition to online). The booth costs her $500 per month.
3. At the start of the year, Alex invested $5,000 into her business (100 common shares). She also obtained a bank loan of $5,000 (ABC has only paid an annual interest of 5%). Other than the bank loan and a $4,200 accounts payable balance, ABC holds no debts.
4. At the start of the year, Alex purchased furniture for $3,000 (expected life of 15 years with no salvage value) and sewing equipment for $2,000 (expected life of 10 years with no salvage value). Both assets are depreciated using the straight-line method.
B.
b) In 2021, Alex plans to double her salary and spend $2,500 on marketing. She projects her cost to rise to $2.25 per bandana, but she expects to sell twice as many units as last year, at a price of $6 apiece. Assuming the other expenses remain constant, what does ABC’s second year look like? Write a short essay on what Alex should expect and give her appropriate business advice (You may use the projections below as part of your analysis).
|
Ratio |
December 31, 2021 projection |
|
Current ratio |
1.50 |
|
Debt-to-Assets |
0.60 |
| Ans A | ||
| ABC | ||
| Details for Financial statements | ||
| 1 | Total purchase @$2= | $ 10,000 |
| Sales price/unit | $ 5 | |
| Sales Revenue | $ 25,000 | |
| Cash purchase of inventory | $ 4,200 | |
| Remaining cash balance=5950-4200= | $ 1,750 | |
| 2 | Annual salary @1000/month | $ 12,000 |
| Booth Rental exp @500/month | $ 6,000 | |
| 3 | Equity investmnet (100 shares) | $ 5,000 |
| Bank Loan | $ 5,000 | |
| Interest exp in 2020 @5% | $ 250 | |
| Accounts Payable balance | $ 4,200 | |
| 4 | Furniture cost | $ 3,000 |
| Salvage value | $ - | |
| Life in years | $ 15 | |
| Annual depreciation exp | $ 200 | |
| Sewing M/C cost | $ 2,000 | |
| Salvage value | $ - | |
| Life in years | $ 10 | |
| Annual depreciation exp | $ 200 | |
| Ans B | ||
| 2021 Projection | ||
| ABC | ||
| Income statement for the year 2021 | ||
| Details | Amt $ | |
| Sales Revenue | $ 60,000 | |
| Less Operating Costs | ||
| Purchase | $ 22,500 | |
| Salary expense | $ 24,000 | |
| Booth rental expense | $ 6,000 | |
| Marketing spend | $ 2,500 | |
| Interest expense | $ 250 | |
| Depreciation expense | $ 400 | |
| Total Operating Expense | $ 55,650 | |
| Net Income/(Loss) | $ 4,350 |
| ABC | |
| Income statement for the year 2020 | |
| Details | Amt $ |
| Sales Revenue | $ 25,000 |
| Less Operating Costs | |
| Purchase | $ 10,000 |
| Salary expense | $ 12,000 |
| Booth rental expense | $ 6,000 |
| Interest expense | $ 250 |
| Depreciation expense | $ 400 |
| Total Operating Expense | $ 28,650 |
| Net Income/(Loss) | $ (3,650) |
| ABC | |||
| Balance Sheet as on 12/31/2020 | |||
| Assets | Amt $ | Liabilities & Equity | Amt$ |
| Cash | $ 1,750 | Accounts Payable | $ 4,200 |
| Inventory | $ 4,200 | Bank Loan | $ 5,000 |
| Total Current Asset | $ 5,950 | Total Current Liabilities | $ 9,200 |
| Fixed Asset | Equity | ||
| Furniture | $ 3,000 | Common share | $ 5,000 |
| Sewing Machine | $ 2,000 | Rteined Earning | $ (3,650) |
| Accumulated depreciation | $ (400) | Total Shareholder Equity | $ 1,350 |
| Net Fixed Asset | $ 4,600 | ||
| Total Asset | $ 10,550 | Total Liabilities & Equity | $ 10,550 |
| Ans B | |
| 2021 Projection | |
| ABC | |
| Income statement for the year 2021 | |
| Details | Amt $ |
| Sales Revenue | $ 60,000 |
| Less Operating Costs | |
| Purchase | $ 22,500 |
| Salary expense | $ 24,000 |
| Booth rental expense | $ 6,000 |
| Marketing spend | $ 2,500 |
| Interest expense | $ 250 |
| Depreciation expense | $ 400 |
| Total Operating Expense | $ 55,650 |
| Net Income/(Loss) | $ 4,350 |
| So ABC can make profit in 2021. | |||
| However in the absence of details about Balance sheet items , the BS details cannot be completed. |