financial accounting

User Generated

wzbavdhr78

Business Finance

Description

ACT301_CT_Mod02_Opt1_Worksheet-2.xlsx

Important! Read First

Choose one of the following two assignments to complete this week. Do not do both assignments. Identify your assignment choice in the title of your submission.


Option 1: Income and Retained Earnings Statements for Buffalo Delivery Service

Scroll to the bottom of the page to download the Option 1 workbook file containing data and a workspace to enter your responses. This file will be your only delivery for this assignment.

Based on the accounts of the ledger of Buffalo Delivery Service (the first tab of the workbook), prepare an income statement and a retained earnings statement for the month of August 2014 and prepare a classified balance sheet for August on the second and third tabs respectively.

Then in the space provided on the fourth tab, write a short analysis and proposal regarding what Buffalo Delivery Service should do to control costs and attract more investors, identifying areas of concern from the investor’s perspective. Support your answer with specific reference to financial data. The written segment of your assignment should be 300-500 words in length and reference at least two credible sources (which may include the textbook) to support your analysis.

Option 2: Trial Balance for Bill’s Delivery Service

Scroll to the bottom of the page to download the Option 2 workbook file containing data and workspace to enter your responses. This file will be your only delivery for this assignment.

Based on the accounts of the ledger of Bill’s Delivery Service (the first tab of the workbook), fill in the missing amount for cash. On the second tab, prepare a trial balance, with the accounts arranged as illustrated in the required readings for the week. On the space provided on the third tab, write a few paragraphs describing what Bill’s Delivery Service should do to control costs and attract more investors, identifying areas of concern from the investor’s perspective. Support your answer with specific reference to financial data. The written segment of your assignment should be 300-500 words in length and reference at least two credible sources (may include the textbook) to support your analysis.


Unformatted Attachment Preview

The accounts in the ledger of Buffalo Delivery Service contain the following balances on August 31, 2014. Accounts Receivable Accounts Payable Cash Equipment Utilities Expense Insurance Expense Notes Payable, due 2017 $11.400 7.400 15.940 59.360 950 600 31.450 Prepaid Insurance Maintenance and Repairs Expense Service Revenue Dividends Common Stock Salaries and Wages Expense Salaries and Wages Payable Retained Earnings (August 1, 2014) On Tab 2 fill in the proper account names in the shaded areas ances on August 31, 2014. $1.800 1.200 15.500 800 40.000 8.400 900 5.200 Fill in the proper account names in the shaded areas and all quantities as directed in the assigniment. Do not delete foruma BUFFALO DELIVERY SERVICE Income Statement For the Month Ended August 31, 2014 Revenues Expenses Total Expenses Net income BUFFALO DELIVERY SERVICE Retained Earnings Statement For the Month Ended August 31, 2014 Retained earnings, July 1st Add: Net Income Less: Dividends Retained earnings, July 31st the assigniment. Do not delete forumas! $ $ $ $ $ - $ $ - $ $ $ $ $ - - Fill in the proper account names in the shaded areas and all quantities as directed in the assigniment. Do not delete foruma BUFFALO DELIVERY SERVICE Balance Sheet August 31, 2014 Assets Current Assets: $ $ $ - Total Current Assets Total assets $ $ $ - $ $ $ - $ $ - Liabilities & Stockholders' Equity Current Liabilities $ $ - Total current liabilities Total liabilites Stockholderss' equity $ $ Total stockholders' equity Total liabilitiess & stockholders' equity - Provide the written part of your assignment in the space below NOTE: use Alt+Enter to create paragraph spacing The accounts in the ledger of Bills Delivery Service contain the following balances on July 31, 2014. Accounts Receivable Accounts Payable Cash Equipment Gasoline Expense Insurance Expense Notes Payable, due 2017 $16,400 12,400 ? 59,360 950 600 28,450 Prepaid Insurance Maintenance and Repairs Expense Service Revenue Dividends Common Stock Salaries and Wages Expense Salaries and Wages Payable Retained Earnings (July 1, 2014) On this tab, calculate and fill in the cash amount. On Tab 2: Insert all accounts in proper order and fill in all quantites as directed in the assignment description. July 31, 2014. $1,800 1,200 13,500 800 50,000 6,400 900 5,200 he assignment description. Insert all accounts in proper order and fill in all quantites as directed in the assignment description. Do not delete formulas BILL’S DELIVERY SERVICE Trial Balance 31-Jul-14 Debit Total $ Credit - $ - n. Do not delete formulas! Both Colums Must Balance Provide the written part of your assignment in the space below NOTE: use Alt+Enter to create paragraph spacing
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Just the thing I needed, saved me a lot of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags