BUS 650 Final Project -Controllership (100% Reliable Paper)
Controllership BUS 650-(01&02)
Final Project – Part 1
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.
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.
Bad Debt Estimate
30-60 Days Past Due
Over 60 Days Past Due
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.
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.