ABC Company - Biographical Information ABC Company is a family owned business which Jonathan started 15 years ago, issuing 900 shares of the 1000 authorized, at a par value of $100 a share. ABC Company is a small manufacturer which produces ladies’ sports apparel. The business has employed as many as 30 people; however, sales have slipped the last three years, according to Jonathan, due to competition in the marketplace, and the economy. Currently, the business employs nine people, including Jonathan and his son, Junior, who is the Plant Manager. The business appears to be on pace to produce about the same as last year, $800,000, which is down from their high of about $2,500,000 just four years ago. Jonathan’s family is personally in financial trouble, because Jonathan and Junior aren’t taking home the same salary they used to. Three years ago, each of them earned $200K per year. At the time of our arrival, Jonathan hadn’t taken any pay for a month, and Junior is being paid at the rate of $50K per year. Jonathan has a few health issues, and wants Junior to take over the business, but can’t afford to hire a new Plant Manager. Morale throughout the company is low, and productivity is suffering. ABC Company sold 12,307 units last year. 85% of the sales were in workout leggings. Remaining sales were from one order of sweatshirts by their oldest customer. They are behind in payables and past due receivables are at an all time high. Their customer base consists mainly of three local retailers who love working with Jonathan and Junior and have been customers for years. Vendors are getting tired of being paid late, and their primary fabric vendor has just recently put them on COD. There is a loan on the books from Junior’s mother-in-law for $30,000, with a pay plan of $750 a month, but the Company has missed the last three payments and Junior and his wife are becoming increasingly upset about the embarrassment and problems this is causing in their family life.
See attached picture for TWO part question: Creating a Income Statement and doing a Six Week Cash Flow Projection
ABC Company | ||
Statement of Profit and Loss | ||
Particulars | Amount | |
Revenue | $ 821,500 | |
Less : | Discount and Allowances | $ 21,500 |
Material Purchase ( Net of Disc) | $ 283,980 | |
Sales Commissions | $ 40,000 | |
Gross Margin | $ 476,020 | |
Other Income | ||
- Supplies Sales | $ 2,250 | |
Total | $ 478,270 | |
Operational Expenses | ||
Advertising Expenses | $ 7,500 | |
Accounting Fees | $ 6,000 | |
Bank Fees | $ 4,450 | |
Freight | $ 5,200 | |
Rent | $ 30,000 | |
Office Supplies | $ 6,000 | |
Dues and subscription | $ 620 | |
Maintainence | $ 39,940 | |
Franchise | $ 6,500 | |
Payroll Expenses | ||
Payroll - Administrative | $ 44,000 | |
Payroll - Direct Labour | $ 202,210 | |
Payroll - Management | $ 50,000 | |
Payroll - Overtime | $ 13,600 | |
Payroll Taxes | $ 15,000 | |
Earnings before Interest and Tax | $ 47,250 | |
Interest Expense | $ 4,000 | |
Earnings before Tax | $ 43,250 | |
Income Tax | $ 800 | |
Net Operating Income | $ 42,450 | |
ABC Company | ||||||
Cash Flow Projection | ||||||
Particulars | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 |
Opening Balance | $ 7,000 | $ 4,684 | $ 14,684 | $ 1,118 | $ 16,518 | $ 5,102 |
Collections from AR : | ||||||
Over 90 Days | $ 24,000 | $ 18,000 | $ 12,000 | $ 20,000 | ||
90 Days | ||||||
60 Days | ||||||
30 Days | $ 29,600 | $ 6,000 | ||||
Total | $ 31,000 | $ 22,684 | $ 26,684 | $ 21,118 | $ 46,118 | $ 11,102 |
Payroll Expenses | $ 11,916 | $ 11,916 | $ 11,916 | |||
Payroll Taxes | $ 1,250 | $ 1,250 | ||||
Truck Lease | $ 550 | $ 550 | ||||
Payment on Building | $ 2,500 | $ 2,500 | ||||
Equipment Loan | $ 1,350 | |||||
Accountant Fees | $ 1,200 | |||||
Telephone Expenses | $ 650 | |||||
Utilities Expenses | $ 850 | $ 850 | ||||
Loan Payback | $ 750 | $ 750 | ||||
AP Payment | ||||||
Over 90 Days | $ 9,100 | $ 6,200 | $ 13,000 | $ 2,000 | $ 25,000 | $ 6,000 |
Closing Balance | $ 4,684 | $ 14,684 | $ 1,118 | $ 16,518 | $ 5,102 | $ 4,552 |
Note : AP standard O/s for 60 Days is considered.
AR standard recievable is considered at 30 days o/s.
ABC Company - Biographical Information ABC Company is a family owned business which Jonathan started 15...
ABC Company is a family owned business which Jonathan started 15 years ago, issuing 900 shares of the 1000 authorized, at a par value of $100 a share. ABC Company is a small manufacturer which produces ladies’ sports apparel. The business has employed as many as 30 people; however, sales have slipped the last three years, according to Jonathan, due to competition in the marketplace, and the economy. Currently, the business employs nine people, including Jonathan and his son, Junior,...
1) ABC Company started business on January 1, 2018 and had the following transactions in the month of January 2018: 1. On January 2, ABC sold shares of the company and received $800,000 in cash 2. On January 4, the company bought inventory for resale from RTY Co. and promised to pay cash at a later date. The cost of the inventory was $400,000. 3. On January 8, ABC sold inventory to YUT Co. at a sale price of $400,000....
The following transactions occurred at the Daisy King Ice Cream Company 1. Started business by issuing 10,000 shares of common stock for $26,000 2. Leased a building for three years at $560 per month and paid six months' rent in advance. 3. Purchased equipment for $6,000, signing a two-year, 12% note. 4. Purchased $2,400 of supplies on account. 5. Recorded cash sales of $1,400 for the first week. 6. Paid weekly salaries, $620. 7. Paid for supplies purchased in item...
ABC Services, Inc. is the company you started on December 1, 2019. The following transactions occurred during the month of December 2019: 1 . The business was started with a $10,000 capital investment from the owner and sole shareholder on December l, 2019. Additional business funding of $10,000 was obtained from a bank 'loan the same day. (90 day note) 2. Rent of $6,000 for the first 3 months was required which included rent of $2,000 for the month of...
Home Entertainment is a small, family-owned business that purchases LCD televisions from a reputable manufacturer and sells them at the retail level. The televisions sell, on average, for $2,290 each. The average cost of a television from the manufacturer is $1,400. Home Entertainment has always kept careful accounting records, and the costs that it incurs in a typical month are as follows: Costs Cost Formula Selling: Advertising $ 1,400 per month Delivery of televisions $ 42 per television sold...
You are the co-founder of ABC T-Shirts Limited, a T-shirt clothing company that has been trading for the past three years with limited success. You have now made the decision to seek external investment into the company to expand into sports equipment market. As part of the due diligence process, potential investors have asked you to prepare a cash flow statement for the first quarter 2017. Your records show ABC T-Shirts Limited will have the following balances on the 1st...
ABC Corporation has hired you to help with their accounting. ABC is a wilderness adventure company in Whitehorse, YT. They operate from May 1st to September 30th each year, providing tourists with guided wilderness adventures. The owner, Daniel, asks you to help develop pricing for the new season because last year he made less money then he thought. Daniel gives you the following information he used to come up with pricing: Uses home office space Hires a university student as...
Tony formed a business called Tone’s Big Screen TV Emporium Inc. during the month of September. Doors will open for business on October 1. The following occurred during September: Tony invested the following Tony personally borrowed $10,000 from the bank. Tony then invested the funds in the business. Used computer equip. $4,800, originally costing $6,000. Estimates 4 years of service remain. Office equip. worth $2,400, originally costing $6,000. Estimates 5 years of service remain. Called Sony and ordered 10 big...
Company A's business involves hosting several concerts per year. The company's year-end is December 31, 2021. The company records all prepaid costs as assets and all uneamed revenues as liabilities and adjusts accounts annually. 1. Prepaid supplies amounted to $945 on December 31, 2020. On June 10, 2021, additional supplies were purchased for $1,955 cash On December 31, 2021, a physical count showed that prepaid supplies on hand amounted to $840. 2. Purchased equipment on August 1, 2021, for $47,520...
Kenosha Winter Services is a small, family-owned snow-removal business. For its services, the company has always charged a flat fee per hundred square metres of snow removal. The current fee is $11.60 per hundred square metres. However, there is some question about whether the company is actually making any money on jobs for some customers-particularly those located on more remote properties that require considerable travel time. The owner's daughter, home from school for the summer, has suggested investigating this question...