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