You have decided to open a dog-walking company. Happy Pets was incorporated on January 1st, 2019....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have decided to open a dog-walking company. Happy Pets was incorporated on January 1st, 2019. The business maintains a retail pet store, providing gourmet dog food and treats, and also provides a full range of pet care services, including grooming, dog-walking, and boarding. During the year, your company engages in many business transactions. Download the Excel spreadsheet Happy Pets Inc. for your company in the module folder. The spreadsheet includes the following tabs: January 1st February 8th March 1st March 31st April 1st April 10th May 15th May 30th June 1st June 30th July 25th July 31st August 2nd August 6th September 15th September 29th October 13th October 29th November 1st November 15th December 15th Common stock is issued in exchange for cash in the amount of . The company purchases and pays for 170 units of gourmet dog food at a price of $25 per unit. The company pays cash for a one-year insurance policy in the amount of. Rent on a retail space for 12 months is paid in the amount of. Grooming and boarding equipment with a useful life of 2 years is purchased for cash in the amount of ...... Grooming supplies purchased on account in the amount of. The company purchases and pays for another 380 units of gourmet dog food at a price of $29 per unit Grooming services are performed on account in the amount of The company pays for advertisements to be run for the next 12 months in the amount of . The company issues a 5-year notes payable with their bank for $100,000 and interest at an annual rate of 6%. Interest is due on June 30th each year and the principal will be paid in full at the end of the 5 year period. Dog-walking services are performed on account in the amount of ....... 105 units of gourmet dog food are sold for $70 per unit with terms 2/10, n/30. The sale is recorded using the gross method in the amount of (see note e for cost flow assumptions). Boarding services are provided on account in the amount of The company receives full payment from the customer for the July 31st sale. Pet sitting services are performed on account in the amount of Customer payments are received for services previously provided in the amount of 100 units of gourmet dog food are sold for $73 per unit with terms 2/10, n/30. The sale is recorded using the net method in the amount of The company receives payment for half of the October 13th sale Equipment originally purchased on April 1st for $2400 is sold for $2000 cash A bookkeeper is hired to help the company with daily accounting taxes and annual tax preparation The bookkeeper is paid $4,500 for the previous month's services 395,000 4,250 3,900 13,480 22,000 1,540 11,020 12,625 964 100,000 14,522 7,350 6,380 7,203 6,345 1,350 7,300 3,650 4,500 Units 170 380 -105 -100 Unit Cost 25 29 29 29 REQUIRED: 1. 2. 3 4 5. 6. 7. 8. 9. Additional information: a. Grooming supplies on hand at the end of the month are as follows: b. The year-end balance reported at the end of the year for the Allowance for Doubtful Accounts is estimated as 4% of outstanding receivables at the end of the year c. The Company uses a perpetual inventory system and accounts for costs using the First-In-First-Out cost flow assumption. On December 31st, a count of ending inventory reveals that there are 345 bags of dog food on hand. d. All revenue is recorded in the "Sales Revenue" account and reported net of cash discounts on the income statement. e. The effective interest method is used to amortize bond premiums and discounts f. Adjustments are made at the end of the year for prepaid insurance, rent, advertising, depreciation, and interest expense. g. The bookkeeper is paid a salary of $4,500 on the 15th of every month. h. The company declared dividends of $750 for the year i. Assume selling expenses include advertising and supplies expense. All other expenses, other than depreciation and interest expense, are considered general & administrative. 924 PART A Prepare journal entries for each transaction listed above (with descriptions). Post journal entries to the general ledger accounts. Prepare an unadjusted trial balance. Prepare all necessary adjusting journal entries (with descriptions). and post to the general ledger. Prepare an adjusted trial balance on December 31st. Prepare closing entries, post to the general ledger, and carryforward balances to January 1st of the next year. Prepare the following financial statements on December 31st (ignore income taxes): a. Income Statement (multi-step, see Example 5.2 in textbook) b. Statement of Stockholders' Equity c. Balance Sheet (classified) d. Statement of Cash Flows (indirect method) Include a ratio analysis of your company and include the industry averages. Refer to Yahoo Finance or a comparable financial site to locate industry averages for your company. Calculate at least one ratio from each category listed: Liquidity, Solvency, and Profitability, and provide an explanation on what it means to the company (See Chapter 3 in the textbook, pages 128-133 and Chapter 4 in the textbook, pages 193 - 199). Rename the excel file Lastname PortfolioProject Option2.xls and submit your completed project online. Date Accounts Journal Debit Credit Prepaid Insurance Prepaid Rent Prepaid Advertising ASSETS Allowance for Doubtful Accounts Supplies Equipment Accounts Payable Interest Payabla Notes Payable LIABILITIES Dividends Payable Salaries Payable STOCKHOLDERS' EQUITY Common Stock Retained Earnings Cash Discounts TEMPORARY ACCOUNTS Cost of Gands Sold Bad Debt Experie Gain on Sale Dividend Adve Exp Rent Expense Depreciati Salaries Experat Sales revenue (net) Cost of goods sold Gross profit HAPPY PETS Income Statement For the year ended December 31, 2019 Operating expenses: Selling expenses General & administrative expenses Depreciation expense Total operating expenses Operating Income Other items: Interest expense Gain on sale of equipment Net Income Beginning Balance Issuance of Stock Add: Net Income Less: Dividends Ending Balance HAPPY PETS Statement of Stockholders' Equity For the Year Ended December 31st, 2019 Common Stock Retained Earnings Total ASSETS Current assets: Cash Accounts receivable Less: Allowance for doubtful accounts Inventory Supplies Prepaid insurance Prepaid rent Prepaid advertising Total current assets Long-term assets: Equipment Less: Accumulated depreciation Total long term assets TOTAL ASSETS LIABILITIES Current Liabilities: Accounts payable Interest payable Salaries payable Dividends payable Balance Sheet As of December 31st, 2019 Total Current Liabilities Long Term Liabilities Notes payable Total Liabilities STOCKHOLDERS' EQUITY Common Stock Retained Earnings Total Stockholders' Equity TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY HAPPY PETS Statement of Cash Flows For the year ended December 31st, 2019 Cash Flows from Operating Activities Net Income Adjustments for noncash effects: Depreciation expense Bad debt expense Gain on sale of equipment * Changes in current assets and current liabilities: Increase/Decrease in accounts receivable Increase/Decrease in inventory Increase/Decrease in supplies Increase/Decrease in prepaid insurance Increase/Decrease in prepaid rent Increase/Decrease in prepaid advertising Increase/Decrease in accounts payable Increase/Decrease in interest payable Increase/Decrease in salaries payable Net cash flows for operating activities Cash Flows from Investing Activities Purchase of equipment Proceeds from sale of equipment Net cash flows for investing activities Cash Flows from Financing Activities Issuance of common stock Proceeds from bond issuance Payment of dividends Net cash flows from financing activities Net increase in cash Beginning cash balance, Jan. 1 Ending cash balance, December 31 When completing this section, make sure to note whether it should be an "Increase or Decrease" in the account You have decided to open a dog-walking company. Happy Pets was incorporated on January 1st, 2019. The business maintains a retail pet store, providing gourmet dog food and treats, and also provides a full range of pet care services, including grooming, dog-walking, and boarding. During the year, your company engages in many business transactions. Download the Excel spreadsheet Happy Pets Inc. for your company in the module folder. The spreadsheet includes the following tabs: January 1st February 8th March 1st March 31st April 1st April 10th May 15th May 30th June 1st June 30th July 25th July 31st August 2nd August 6th September 15th September 29th October 13th October 29th November 1st November 15th December 15th Common stock is issued in exchange for cash in the amount of . The company purchases and pays for 170 units of gourmet dog food at a price of $25 per unit. The company pays cash for a one-year insurance policy in the amount of. Rent on a retail space for 12 months is paid in the amount of. Grooming and boarding equipment with a useful life of 2 years is purchased for cash in the amount of ...... Grooming supplies purchased on account in the amount of. The company purchases and pays for another 380 units of gourmet dog food at a price of $29 per unit Grooming services are performed on account in the amount of The company pays for advertisements to be run for the next 12 months in the amount of . The company issues a 5-year notes payable with their bank for $100,000 and interest at an annual rate of 6%. Interest is due on June 30th each year and the principal will be paid in full at the end of the 5 year period. Dog-walking services are performed on account in the amount of ....... 105 units of gourmet dog food are sold for $70 per unit with terms 2/10, n/30. The sale is recorded using the gross method in the amount of (see note e for cost flow assumptions). Boarding services are provided on account in the amount of The company receives full payment from the customer for the July 31st sale. Pet sitting services are performed on account in the amount of Customer payments are received for services previously provided in the amount of 100 units of gourmet dog food are sold for $73 per unit with terms 2/10, n/30. The sale is recorded using the net method in the amount of The company receives payment for half of the October 13th sale Equipment originally purchased on April 1st for $2400 is sold for $2000 cash A bookkeeper is hired to help the company with daily accounting taxes and annual tax preparation The bookkeeper is paid $4,500 for the previous month's services 395,000 4,250 3,900 13,480 22,000 1,540 11,020 12,625 964 100,000 14,522 7,350 6,380 7,203 6,345 1,350 7,300 3,650 4,500 Units 170 380 -105 -100 Unit Cost 25 29 29 29 REQUIRED: 1. 2. 3 4 5. 6. 7. 8. 9. Additional information: a. Grooming supplies on hand at the end of the month are as follows: b. The year-end balance reported at the end of the year for the Allowance for Doubtful Accounts is estimated as 4% of outstanding receivables at the end of the year c. The Company uses a perpetual inventory system and accounts for costs using the First-In-First-Out cost flow assumption. On December 31st, a count of ending inventory reveals that there are 345 bags of dog food on hand. d. All revenue is recorded in the "Sales Revenue" account and reported net of cash discounts on the income statement. e. The effective interest method is used to amortize bond premiums and discounts f. Adjustments are made at the end of the year for prepaid insurance, rent, advertising, depreciation, and interest expense. g. The bookkeeper is paid a salary of $4,500 on the 15th of every month. h. The company declared dividends of $750 for the year i. Assume selling expenses include advertising and supplies expense. All other expenses, other than depreciation and interest expense, are considered general & administrative. 924 PART A Prepare journal entries for each transaction listed above (with descriptions). Post journal entries to the general ledger accounts. Prepare an unadjusted trial balance. Prepare all necessary adjusting journal entries (with descriptions). and post to the general ledger. Prepare an adjusted trial balance on December 31st. Prepare closing entries, post to the general ledger, and carryforward balances to January 1st of the next year. Prepare the following financial statements on December 31st (ignore income taxes): a. Income Statement (multi-step, see Example 5.2 in textbook) b. Statement of Stockholders' Equity c. Balance Sheet (classified) d. Statement of Cash Flows (indirect method) Include a ratio analysis of your company and include the industry averages. Refer to Yahoo Finance or a comparable financial site to locate industry averages for your company. Calculate at least one ratio from each category listed: Liquidity, Solvency, and Profitability, and provide an explanation on what it means to the company (See Chapter 3 in the textbook, pages 128-133 and Chapter 4 in the textbook, pages 193 - 199). Rename the excel file Lastname PortfolioProject Option2.xls and submit your completed project online. Date Accounts Journal Debit Credit Prepaid Insurance Prepaid Rent Prepaid Advertising ASSETS Allowance for Doubtful Accounts Supplies Equipment Accounts Payable Interest Payabla Notes Payable LIABILITIES Dividends Payable Salaries Payable STOCKHOLDERS' EQUITY Common Stock Retained Earnings Cash Discounts TEMPORARY ACCOUNTS Cost of Gands Sold Bad Debt Experie Gain on Sale Dividend Adve Exp Rent Expense Depreciati Salaries Experat Sales revenue (net) Cost of goods sold Gross profit HAPPY PETS Income Statement For the year ended December 31, 2019 Operating expenses: Selling expenses General & administrative expenses Depreciation expense Total operating expenses Operating Income Other items: Interest expense Gain on sale of equipment Net Income Beginning Balance Issuance of Stock Add: Net Income Less: Dividends Ending Balance HAPPY PETS Statement of Stockholders' Equity For the Year Ended December 31st, 2019 Common Stock Retained Earnings Total ASSETS Current assets: Cash Accounts receivable Less: Allowance for doubtful accounts Inventory Supplies Prepaid insurance Prepaid rent Prepaid advertising Total current assets Long-term assets: Equipment Less: Accumulated depreciation Total long term assets TOTAL ASSETS LIABILITIES Current Liabilities: Accounts payable Interest payable Salaries payable Dividends payable Balance Sheet As of December 31st, 2019 Total Current Liabilities Long Term Liabilities Notes payable Total Liabilities STOCKHOLDERS' EQUITY Common Stock Retained Earnings Total Stockholders' Equity TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY HAPPY PETS Statement of Cash Flows For the year ended December 31st, 2019 Cash Flows from Operating Activities Net Income Adjustments for noncash effects: Depreciation expense Bad debt expense Gain on sale of equipment * Changes in current assets and current liabilities: Increase/Decrease in accounts receivable Increase/Decrease in inventory Increase/Decrease in supplies Increase/Decrease in prepaid insurance Increase/Decrease in prepaid rent Increase/Decrease in prepaid advertising Increase/Decrease in accounts payable Increase/Decrease in interest payable Increase/Decrease in salaries payable Net cash flows for operating activities Cash Flows from Investing Activities Purchase of equipment Proceeds from sale of equipment Net cash flows for investing activities Cash Flows from Financing Activities Issuance of common stock Proceeds from bond issuance Payment of dividends Net cash flows from financing activities Net increase in cash Beginning cash balance, Jan. 1 Ending cash balance, December 31 When completing this section, make sure to note whether it should be an "Increase or Decrease" in the account
Expert Answer:
Answer rating: 100% (QA)
Question Please hit LIKE button if this helped For any further explanation please put your query in ... View the full answer
Related Book For
Better Business
ISBN: 978-0132496735
2nd edition
Authors: Michael R. Solomon, Mary Anne Poatsy, Kendall Martin
Posted Date:
Students also viewed these accounting questions
-
Create worksheet for the following A Complete Accounting Cycle Project After graduating from College you have decided to open a Bookkeeping Consulting Firm. You did some consulting during last few...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
In Problems 4358, (a) Find the vertex and the axis of symmetry of each quadratic function, and determine whether the graph is concave up or concave down. (b) Find the y-intercept and the...
-
The Bahama Nut Company sells three different half-pound bags of peanut mixes: Party Nuts, Mixed, and Premium Mix. These generate per-bag revenue of $1.00, $2.10, and $3.63, respectively. The tables...
-
The outside diameter of a part used in a gear assembly is known to be normally distributed with a mean of 40 mm and standard deviation of 2.5 mm. The specifications on the diameter are (36,45), which...
-
Conventional financial accounting suggests that environmental permits should be measured by using the historical cost principle. One alternative is that current market prices should be used instead....
-
Continue with the facts of Problem 57. What are the Federal income tax withholding requirements with respect to Martinho's sale? Who pays the withheld amount to the U.S. Treasury?
-
The Psychiatric Hospitals P&L is a classic two-sided marketplace that matches Healthcare Facilities (HCFs) who need last minute shifts filled with Healthcare Professionals (HCPs) nearby who happen to...
-
Determine the forces in members AB , AC , and AD . Point M is the centroid of triangle BCD . The forces are positive if in tension, negative if in compression. B 5.2' M 5.2' 1190 lb x D 5.2 6.6'
-
1. Consider the binary tree on the right. List each of the following: a. all nodes that are leafs b. all pairs of nodes that are siblings c. all ancestors of the node with value 6 d. all descendants...
-
According to the SEC, BellSouths improper accounting for foreign payments in contravention of the Foreign Corrupt Practices Act (FCPA) included all of the following, except: (a) The use of fabricated...
-
According to GAAP, a company is allowed to recognize a profit in its financial statements in respect of the increase in the price of its own shares. True/False
-
According to the SECs AAER 1555, Edison disclosed the existence and amount of its District-Paid Expenses, but did not properly offset them from revenues. True/False
-
BellSouth is presented in the text as an example of the improper disclosure of non-GAAP information. True/False
-
Krispy Kreme also failed to accrue the full amount of incentive compensation expense in accordance with the companys incentive plan. True/False
-
Question 1. A firm has the following account balances Account Balance USD Account $3,500 EUR Account 5,150 GBP Account 1,000 The currency rates are as follows: GBP/USD 1.0010/$ EUR/GBP 0.9855/...
-
Rewrite the code of Figure 7.3 in Ada, Java, or C#. Figure 7.3: template class queue { item items [max_items]; int next_free, next_full, num_items; public: queue () : next_free (0), next_full(0),...
-
Most business owners agree that keeping up with the pace of technological change is a challenging task. Imagine you are the owner of a new business and must decide what technology would best suit...
-
How have the Kindle and the iPad affected the supply and demand for newspapers and other printed material (such as textbooks)? Discuss the impact of technology on those industries that produce...
-
Organizations to promote free trade, like the EU, have had difficulty creating a common currency. Why do you think not all EU countries use the euro? Why do some countries that are not part of the EU...
-
Assume WestJet repaired one of its Boeing 737 aircraft at a cost of \(\$ 0.8\) million, which West Jet paid in cash. Further, assume that the WestJet accountant erroneously capitalized this cost as...
-
Assume that at the beginning of 2020, Porter Airlines purchased a Bombardier Q400 aircraft at a cost of \(\$ 25,000,000\). Porter expects the plane to remain useful for five years \((5,000,000...
-
Assume that on September 30, 2020, Swiss, the national airline of Switzerland, purchased an Airbus aircraft at a cost of \( 40,000,000\) ( \(\) is the symbol for the euro). Swiss expects the plane to...
Study smarter with the SolutionInn App