Instructions The assignment should be prepared in excel Clearly label each section I Actual Financials Prepare the following and be prepared to share in class, if selected 1 P rovide the relevant numbers from the financial statements of Brown Forman Anheuser Busch InBev for the most recent year a Total Revenues minus Total Expenses Net Income b Beginning Retained Earnings Net Income Dividends Other items Ending Retained Earnings c Assets Liabilities Equity d Beginning cash operating cash flow investing cash flow financing cash flow effects of foreign exchange Ending cash 2 List several differences in the format of Brown Forman BUDs Financial Statements II Financial Reporting Mechanics Prepa ration of Template 1 Create an excel worksheet similar to the one used in class a Column A should be for the date, and column b should be used for the transaction description b Include the following accounts , each with a debit column and a credit column Cash, Accounts Receivable, Office Furniture, Accumulated Depreciation, Accounts Payable, Utilities Payable, Common Stock, Retained Earnings, Dividends, Service Revenue, Rent Expense, Salary Expense, Utility Expense, Depreciation Expense c On the first line beneath the labels, e nter the company's beginning account balances as of June 1, 2020 Cash $13,200, Office Furniture $5 , 300, Common Stock $17,000, Retained Earnings $ 1,500 d In columns A and B , list the following dates and descriptions transactions YOU ARE NOT REQUIRED TO ENTER THE AMOUNTS IN THE INDIVIDUAL ACCOUNT COLUMNS In other words, you do not need to enter the transaction details You are preparing a template 5 Jun Paid rent $1,300 7 Jun Purchased office furniture on account $600 14 Jun Paid employee's salary $1,900 18 Jun Received bill for utilities to be paid next month $370 21 Jun Paid $500 of the Accounts Payable 25 Jun Performed accounting services on account, $5,700 28 Jun Paid cash dividends of $100 30 Jun Recorded Depreciation $90 The assignment should be prepared in excel Clearly label each section I Actual Financials Prepare the following and be prepared to share in class, if selected 1 Provide the relevant numbers from the financial statements of Brown Forman Anheuser Busch InBev for the most recent year a Total Revenues minus Total Expenses Net Income b Beginning Retained Earnings Net Income Dividends Other items Ending Retained Earnings c Assets Liabilities Equity d Beginning cash operating cash flow investing cash flow financing cash flow effects of foreign exchange Ending cash 2 List several differences in the format of Brown Forman BUD's Financial Statements II Financial Reporting Mechanics Preparation of Template 1 Create an excel worksheet similar to the one used in class a Column A should be for the date, and column b should be used for the transaction description b Include the following accounts, each with a debit column and a credit column Cash, Accounts Receivable, Office Furniture, Accumulated Depreciation, Accounts Payable, Utilities Payable, Common Stock, Retained Earnings, Dividends, Service Revenue, Rent Expense, Salary Expense, Utility Expense, Depreciation Expense c On the first line beneath the labels, enter the company's beginning account balances as of June 1, 2020 Cash $13 200, Office Furniture S5,300, Common Stock $17,000, Retained Earnings $1,500 d In columns A and B, list the following dates and descriptions transactions YOLLARE NOT UTIN

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 19, 2024

Instructions The assignment should be prepared in excel. Clearly label each section. I. Actual Financials . Prepare the following and be prepared to share in

Instructions

The assignment should be prepared in excel. Clearly label each section.

I. Actual Financials. Prepare the following and be prepared to share in class, if selected.

1. Provide the relevant numbers from the financial statements of Brown-Forman & Anheuser-Busch InBev

for the most recent year

a. Total Revenues minus Total Expenses = Net Income

b. Beginning Retained Earnings + Net Income Dividends Other items = Ending Retained Earnings

c. Assets = Liabilities + Equity

d. Beginning cash + operating cash flow + investing cash flow + financing cash flow +/- effects of foreign exchange = Ending cash

2. List several differences in the format of Brown-Forman & BUDs Financial Statements.

II. Financial Reporting Mechanics Preparation of Template

1. Create an excel worksheet similar to the one used in class.

a. Column A should be for the date, and column b should be used for the transaction description.

b. Include the following accounts, each with a debit column and a credit column: Cash, Accounts Receivable, Office Furniture, Accumulated Depreciation, Accounts Payable, Utilities Payable, Common Stock, Retained Earnings, Dividends, Service Revenue, Rent Expense, Salary Expense, Utility Expense, Depreciation Expense.

c. On the first line beneath the labels, enter the company's beginning account balances as of June 1, 2020: Cash $13,200, Office Furniture $5,300, Common Stock $17,000, Retained Earnings $1,500.

d. In columns A and B, list the following dates and descriptions transactions. YOU ARE NOT REQUIRED TO ENTER THE AMOUNTS IN THE INDIVIDUAL ACCOUNT COLUMNS. In other words, you do not need to enter the transaction details. You are preparing a template.

5-Jun	Paid rent $1,300
7-Jun	Purchased office furniture on account $600
14-Jun	Paid employee's salary $1,900
18-Jun	Received bill for utilities to be paid next month $370
21-Jun	Paid $500 of the Accounts Payable
25-Jun	Performed accounting services on account, $5,700
28-Jun	Paid cash dividends of $100
30-Jun	Recorded Depreciation $90

The assignment should be prepared in excel. Clearly label each section. I. Actual Financials. Prepare the following and be prepared to share in class, if selected. 1. Provide the relevant numbers from the financial statements of Brown-Forman & Anheuser-Busch InBev for the most recent year a. Total Revenues minus Total Expenses = Net Income b. Beginning Retained Earnings + Net Income - Dividends - Other items - Ending Retained Earnings c. Assets - Liabilities + Equity d. Beginning cash + operating cash flow + investing cash flow + financing cash flow +/- effects of foreign exchange = Ending cash 2. List several differences in the format of Brown- Forman & BUD's Financial Statements. II. Financial Reporting Mechanics - Preparation of Template 1. Create an excel worksheet similar to the one used in class. a. Column A should be for the date, and column b should be used for the transaction description b. Include the following accounts, each with a debit column and a credit column: Cash, Accounts Receivable, Office Furniture, Accumulated Depreciation, Accounts Payable, Utilities Payable, Common Stock, Retained Earnings, Dividends, Service Revenue, Rent Expense, Salary Expense, Utility Expense, Depreciation Expense. c. On the first line beneath the labels, enter the company's beginning account balances as of June 1, 2020: Cash $13.200, Office Furniture S5,300, Common Stock $17,000, Retained Earnings $1,500. d. In columns A and B, list the following dates and descriptions transactions YOLLARE NOT UTIN