BUS 650 Final Project -Controllership

Controllership  BUS 650-(01&02)

Final Project – Part 1

Kenny LeGrand

Due before class final (Part2)

Please download the Excel file labeled “Final Project” and follow the steps below.

1)      Notice that some of the Balance Sheet and Income Statement lines and are not on the first tab of the excel sheet.  The second tab shows the missing lines.  Copy and paste the lines into the proper place on the balance sheet or income statement.  If done properly, the X0 Balance Sheet column will balance.

2)      Calculate and place the missing numbers for X1 in the proper place on the Balance Sheet and/or Income Statement using the following information.  If done properly, the Balance Sheet and Cash Flow Statements will balance for X1.

a.       The company paid out $100 in dividends in year X1.

b.      During X1, the company purchased and paid for $1,350 in Advertising of which $750 will be used next year.

c.       The company assembled the following information regarding Accounts Receivable and Bad Debts at the end of year X1.  Use this information to increase the allowance account and record bad debt expense.

d.      Interest Expense during X1 was $1,000.

e.      In X1, the company purchased a new machine for $5,000.  No other equipment was purchased or sold.

f.        The company depreciates some of its assets using the straight line method and others using the double declining balance method.  Depreciation should be calculated using the following information.  As a rule, the company does not use a residual value for any of its assets.  Assume a full year of depreciation on the new equipment item.

g.       Inventory at the end of X1 had increased by $1,500.

h.      Office wages paid during the year totaled $3,700.  An additional $300 of office wages were earned during X1 but were paid in the following year.

i.         During X1, the company paid off $1,000 of debt to the bank.  However the company borrowed $4,000 to buy the new piece of equipment.

3)      Calculate the ratios to the right of the Statement of Cash Flows.  For all items except “Working Capital”, if you place the numerator and denominator in the first column the second column will calculate the answer.  The second column will calculate an answer no matter what values you use so careful to use the correct values.