This project should be completed using Excel (with formulas and linked data). The parameters of the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This project should be completed using Excel (with formulas and linked data). The parameters of the project are below: 1. Prepare a Multi-step Income Statement for the year ended 2018. This statement should be flexibly designed (formulas) with common-sized percentages (vertical analysis) to the right of the dollars. 2. Show journal entries, adjusting entries and closing entries for the below additional information...none of the journal entries have been posted to the ledger (many journal entries have been booked to get you started, however none of the entries for 2018 have been posted). You can add a transaction analysis (not required), however you must complete the entries in the Excel template. Prepare a Statement of Retained Earnings for the year ended 2018. 3. 4. Prepare a Balance Sheet dated Dec. 31, 2018. Again a flexible design is required so any changes will automatically update the balance sheet - use formulas. 5. Prepare a Statement of Cash Flows using the indirect method for the year ended 2018. The ending cash as shown on the statement of cash flows will be the same as the cash reported on the Balance Sheet. Current Assets Cash Marketable Securities (Short-term) Accounts Receivable Allowance for Bad Debt Your Name, Inc. Balance Sheet 12/31/2017 Inventory Prepaid Insurance Total Current Assets Property, Plant, and Equipment Land Building Accumulated Dep. - Building Equipment Accumulated Dep. - Equipment Total PPE Total Assets Current Liabilities Accounts Payable Unearned Revenue Income Taxes Payable Total Current Liabilities Long-term Liabilities Bonds, 10%, due in 2022 $17,000 2,000 14,000 (2,000) 15,000 5,000 $51,000 $30,000 150,000 (45,000) 100,000 (20,000) $215,000 $266,000 $9,000 2,000 3,000 $14,000 $100,000 Equity Common Stock (100,000 authorized, 50,000 issued) Additional Pd.-in Capital $ 50,000 4. Inventory: Retained Earnings Total Equity Total Liabilities & Equity Additional Information (for all entries; please see the posted Excel spreadsheet): 1. Sales for 2018 are $310,000. All sales are on credit. 2. Gross Margin ratio is 40 percent 3. Accounts Receivable: 80,000 22,000 $152,000 $266,000 i. $190,000 of the accounts receivable is paid by the end of the year (the remaining balance remains on the balance sheet). ii. $4,000 of A/R is written off during the year. iii. 5% of A/R (after write-off and collections) is considered to be uncollectible. i. Inventory purchases are $180,000, all on credit. ii. All accounts payable is from inventory purchases; all but $12,000 of inventory purchased is paid by the end of the year. 5. Additional equipment is purchased on 4/1/18 for $20,000 cash. All equipment when new, including the new purchase, has/had a 5-year life, no salvage value, and is depreciated using the straight-line method. 6. The building depreciates at $5,000 per year. 7. Half of the marketable securities were sold for $1,200. The FMV and cost of the other half of the securities are the same, so no adjustment to FMV is required. 8. Salaries are $2,200 per month (12 months of salaries expense must be booked). It is expected that one- half month will be owed on 12/31/18 because of when payday falls (therefore, 11.5 months of salaries have been paid and ½ month is still owed to the employees at year end). 9. $55,000 in cash is borrowed on 9/30/18 by issuing a Note Payable. Interest is 8% per year. 10. The bonds were sold at face value last December and pay interest on Dec. 31, 2018. 11. 10,000 additional shares of stock were sold for $3 a share. 12. Insurance costing $18,000 was purchased on 6/1/18 (the same time in which the old policy expired. The new policy was for 12 months). 13. On Dec. 31, 2018, 1000 shares of stock are repurchased from the market at $2.90/share (treasury stock). 14. The tax rate is 30 percent. Income taxes for the current year are due and therefore paid during the first two months of the next year (you will have to complete an entry to pay the 2017 taxes, however the 2018 taxes will not be paid until the end of January 2019). 15. Dividends of $3,000 were paid during 2018. 16. The unearned revenue has been earned during the year (classified as other revenue on the multi-step income stmt.). 7. Cash Flow Statement 8. Post-Close Trial Balance for 2018 Required Labeled Sheets (all statements should be for 2018): 1. Data Sheet for Additional Data 2. Entries: Basic and Adjusting (you do not have to show closing entries, however, keep in mind all temporary accounts are closed to retained earnings) 3. Adjusted Trial Balance for 2018 (includes the posted amounts of all entries and adjusting entries) 4. Multi-step Income Statement 5. Retained Earnings Statement 6. Classified Balance Sheet The Post-Close Trial Balance for 2017 is provided below (based on the above balance sheet). This can be used as a starting point or you can use the above Balance Sheet; keep in mind all debits and credits ALWAYS equal AND Assets = Liabilities + Equity: Cash Your Name, Inc. Post Close Trial Balance 31-Dec-17 Marketable Securities. Accounts Rec. Allowance for Bad Debt Inventory. Prepaid Insurance Land Building Accumulated Dep. Building. Equipment Accumulated Dep.- Equipment Accounts Payable Salaries Payable Unearned Revenue Interest Payable Income Taxes Payable Note Payable Bonds Common Stock Additional Pd-in-Capital Retained Earnings DEBITS 17,000 2,000 14,000 15,000 5,000 30,000 150,000 100,000 333,000 CREDITS 2,000 45,000 20,000 9,000 2,000 3,000 100,000 50,000 80,000 22,000 333,000 This project should be completed using Excel (with formulas and linked data). The parameters of the project are below: 1. Prepare a Multi-step Income Statement for the year ended 2018. This statement should be flexibly designed (formulas) with common-sized percentages (vertical analysis) to the right of the dollars. 2. Show journal entries, adjusting entries and closing entries for the below additional information...none of the journal entries have been posted to the ledger (many journal entries have been booked to get you started, however none of the entries for 2018 have been posted). You can add a transaction analysis (not required), however you must complete the entries in the Excel template. Prepare a Statement of Retained Earnings for the year ended 2018. 3. 4. Prepare a Balance Sheet dated Dec. 31, 2018. Again a flexible design is required so any changes will automatically update the balance sheet - use formulas. 5. Prepare a Statement of Cash Flows using the indirect method for the year ended 2018. The ending cash as shown on the statement of cash flows will be the same as the cash reported on the Balance Sheet. Current Assets Cash Marketable Securities (Short-term) Accounts Receivable Allowance for Bad Debt Your Name, Inc. Balance Sheet 12/31/2017 Inventory Prepaid Insurance Total Current Assets Property, Plant, and Equipment Land Building Accumulated Dep. - Building Equipment Accumulated Dep. - Equipment Total PPE Total Assets Current Liabilities Accounts Payable Unearned Revenue Income Taxes Payable Total Current Liabilities Long-term Liabilities Bonds, 10%, due in 2022 $17,000 2,000 14,000 (2,000) 15,000 5,000 $51,000 $30,000 150,000 (45,000) 100,000 (20,000) $215,000 $266,000 $9,000 2,000 3,000 $14,000 $100,000 Equity Common Stock (100,000 authorized, 50,000 issued) Additional Pd.-in Capital $ 50,000 4. Inventory: Retained Earnings Total Equity Total Liabilities & Equity Additional Information (for all entries; please see the posted Excel spreadsheet): 1. Sales for 2018 are $310,000. All sales are on credit. 2. Gross Margin ratio is 40 percent 3. Accounts Receivable: 80,000 22,000 $152,000 $266,000 i. $190,000 of the accounts receivable is paid by the end of the year (the remaining balance remains on the balance sheet). ii. $4,000 of A/R is written off during the year. iii. 5% of A/R (after write-off and collections) is considered to be uncollectible. i. Inventory purchases are $180,000, all on credit. ii. All accounts payable is from inventory purchases; all but $12,000 of inventory purchased is paid by the end of the year. 5. Additional equipment is purchased on 4/1/18 for $20,000 cash. All equipment when new, including the new purchase, has/had a 5-year life, no salvage value, and is depreciated using the straight-line method. 6. The building depreciates at $5,000 per year. 7. Half of the marketable securities were sold for $1,200. The FMV and cost of the other half of the securities are the same, so no adjustment to FMV is required. 8. Salaries are $2,200 per month (12 months of salaries expense must be booked). It is expected that one- half month will be owed on 12/31/18 because of when payday falls (therefore, 11.5 months of salaries have been paid and ½ month is still owed to the employees at year end). 9. $55,000 in cash is borrowed on 9/30/18 by issuing a Note Payable. Interest is 8% per year. 10. The bonds were sold at face value last December and pay interest on Dec. 31, 2018. 11. 10,000 additional shares of stock were sold for $3 a share. 12. Insurance costing $18,000 was purchased on 6/1/18 (the same time in which the old policy expired. The new policy was for 12 months). 13. On Dec. 31, 2018, 1000 shares of stock are repurchased from the market at $2.90/share (treasury stock). 14. The tax rate is 30 percent. Income taxes for the current year are due and therefore paid during the first two months of the next year (you will have to complete an entry to pay the 2017 taxes, however the 2018 taxes will not be paid until the end of January 2019). 15. Dividends of $3,000 were paid during 2018. 16. The unearned revenue has been earned during the year (classified as other revenue on the multi-step income stmt.). 7. Cash Flow Statement 8. Post-Close Trial Balance for 2018 Required Labeled Sheets (all statements should be for 2018): 1. Data Sheet for Additional Data 2. Entries: Basic and Adjusting (you do not have to show closing entries, however, keep in mind all temporary accounts are closed to retained earnings) 3. Adjusted Trial Balance for 2018 (includes the posted amounts of all entries and adjusting entries) 4. Multi-step Income Statement 5. Retained Earnings Statement 6. Classified Balance Sheet The Post-Close Trial Balance for 2017 is provided below (based on the above balance sheet). This can be used as a starting point or you can use the above Balance Sheet; keep in mind all debits and credits ALWAYS equal AND Assets = Liabilities + Equity: Cash Your Name, Inc. Post Close Trial Balance 31-Dec-17 Marketable Securities. Accounts Rec. Allowance for Bad Debt Inventory. Prepaid Insurance Land Building Accumulated Dep. Building. Equipment Accumulated Dep.- Equipment Accounts Payable Salaries Payable Unearned Revenue Interest Payable Income Taxes Payable Note Payable Bonds Common Stock Additional Pd-in-Capital Retained Earnings DEBITS 17,000 2,000 14,000 15,000 5,000 30,000 150,000 100,000 333,000 CREDITS 2,000 45,000 20,000 9,000 2,000 3,000 100,000 50,000 80,000 22,000 333,000
Expert Answer:
Answer rating: 100% (QA)
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 31 32 33 34 35 36 37 38 39 40 ... View the full answer
Related Book For
Principles of Accounting
ISBN: 978-0618736614
10th edition
Authors: Belverd Needles, Marian Powers, Susan Crosson
Posted Date:
Students also viewed these finance questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
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...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
The CFO of the Jordan Microscope Corporation intentionally misclassified a downstream transportation expense in the amount of $575,000 as a product cost in an accounting period when the company made...
-
The information that follows pertains to Richards Refrigeration, Inc.: a. At December 31, 2011, temporary differences existed between the financial statement carrying amounts and the tax bases of the...
-
What are the three potential tax treatments of a cash distribution to a shareholder? Are these potential tax treatments elective by the shareholder?
-
What are the reasons for most companies having a poorly co-ordinated collection of environmental data? How are these reasons related to the distinction made between fixed and variable costs of...
-
The Best Beer Corporation has a beer-processing facility located in Columbus, Ohio. The beer facility has a system efficiency of 90 percent, and the utilization is 80 percent. Three sub-facilities...
-
What innovative methodologies can leaders employ to cultivate a diverse and inclusive workforce, thereby capitalizing on the manifold perspectives and experiences to foster creativity and drive...
-
Juliette White is a head of household taxpayer with a daughter named Sabrina. They live at 1009 Olinda Terrace, Apt. 58, Reno, NV 78887. Juliette works at a local law firm, Law Offices of Dane Gray,...
-
1. Design a DFA over the alphabet E= {0, 1} that will recognize the language L(A) = {ww has both an even number of 0's and and even number of 1's } 2. For cach casc below, design a DFA A over the...
-
I am trying to answer the questions and getting stuck. PERSONAL FINANCIAL STATEMENT AS OF SUBMITTED TO: PERSONAL INFORMATION Kaitlyn Nieson APPLICANT (NAME) Employer and Address Dry Supply, Inc....
-
Assume the Giada Coffee Roasters Corp. ended the month of August 2022 with these data: Payments of cash: Acquisition of equipment....... $201,500 Dividends.... Retained earnings August 1, 2022.....
-
Prove that if every subsequence of {xn}eR converges to a, then xn converges to a.
-
How can managers create an environment that encourages open communication and feedback from their employees?
-
The financial advisor to EEW Company is evaluating whether to keep company cars for 3, 4 or 5 years. The following information has been gathered:- A car costs $60,000 and depreciation is 20% pa...
-
In this assignment, you'll write two clients (both essentially identical) that will communicate with a server that you will also write. On start-up, each client will print out a string saying:...
-
14. In testing the existence assertion, an auditor ordinarily works from the a. Financial statements to the accounting records. b. General journal to the general ledger. c. Supporting evidence to the...
-
Percival Burglar Alarm Systems Company purchased a computer for $1,120. It has an estimated useful life of four years and an estimated residual value of $120. Compute the depreciation charge for each...
-
How important are accrued expenses? Randomly choose four different companies. Go to each company's website and find their annual reports. For each company, find the section of the balance sheet...
-
Dell Computer Corporation has significant investment activities. The following items are from Dell's fiscal year 2006 financial statements (in millions):15 Short-term...
-
Why are ethics crucial in accounting?
-
Why are ethics and social responsibility valuable to organizations?
-
Who sets U.S. accounting rules?
Study smarter with the SolutionInn App