N21 Xfx B D E 1 MGT2303.Fnal Project 2 3 Part 5: (a) Valuation for Purchase 4 5. The following information was pulled from a companies current annual financial statements 6 7 Account Values 8 9 Depreciation Expencse - Trucks $10,000 10 Revenue $150,000 11 Accumulated Depreciation - Trucks $70,000 12 Accounts Payable $10,000 13. Cash $2.000 14 Wages Expense $40,000 15 Accounts Receivable + $70,000 16 Trucks $100,000 17 Gas Expense $20,000 10 Other equipment and tools $4.000 19 Rent Expense 524,000 20 21 Other information: 22 - Income for the previous 4 years oldest to most recent: 23 Year 4- $25,000; Year 3 $30,000; Year 2 - $50,000; Year 1 - $55,000 243% of the company's accounts receivable is considered uncollectible 25 - The market rate for rent for similar units is $2,200 per month The mechanic says the trucks are in good shape and should last at least another 3 years maintenance expenses should run $5,000 per season 2 A review of current contract shows one for the town municipal properties 29 for the past three years is ending and will not be renewed. The value of the contract was $30,000 per season 3 Conversations with Domenals the charges personal expenses to the company The amount is approximately 54.000 per season would 25% rate of return on hiavetinent 35 Cover Page for Excel Work T-Accounts and Trial Balance AGT2303 - Final Project - Excel Worksheets View Tell me Share General Insert V v 4.0 FO D Dalato $ % ) 8-98 Conditional Format Cell Formatting as Table Styles Format Sort & Filter Find & Select Analy Data H M 0 Cew the wood business in the bed Financial Statements Payroll Valuation MacBook Air Formatting as Table Styles Format M Calculate the value of Born's business using the asset-based Calculate the value of Bjorn's business using the samnings-based method. Excel Work T-Accounts and Trail Balance Financial Statements Payroll Valuation MacBook Air X Calibri (Body) v 11 ' " Paste I U V A N21 A 8 D E 3. Part 5: (a) Valuation for Purchase 4 5. The following information was pulled from a companies current annual financial statements Account Values 9 Depreciation Expencse - Trucks $10,000 10 Revenue $150,000 11 Accumulated Depreciation - Trucks $70,000 12 Accounts Payable $10,000 13 Cash $2,000 14 Wages Expense $40,000 15 Accounts Receivable $70,000 16 Trucks $100,000 17 Gas Expense $20,000 18 Other equipment and tools $4,000 19 Rent Expense $24,000 20 21 Other information: 22 Income for the previous 4 years oldest to most recent! 28 Year 4- $25,000; Year 3 -$30,000; Year 2 - $50,000, Year 1 - $55,000 24 3% of the company's accounts receivable is considered uncollectible 25 The market rate for rent for similar units is $2,200 per month 26. The mechanic says the trucks are in good shape and should last at least another 3 years 27 maintenance expenses should run $5,000 per season 28 review of current contracts shows one for the town municipal properties 229 for the past three years is ending and will not be renewed. 30 The value of the contract was $30,000 per season 31 Conversations with Bjorn reveals hecharges personal gas expenses to the company 2 the amount is approximately $4,000 per season Baker would likea 25 rate of return on his investment Cover Page for Excel Work T-Accounts and Trial Balance Financial Sta N21 Xfx B D E 1 MGT2303.Fnal Project 2 3 Part 5: (a) Valuation for Purchase 4 5. The following information was pulled from a companies current annual financial statements 6 7 Account Values 8 9 Depreciation Expencse - Trucks $10,000 10 Revenue $150,000 11 Accumulated Depreciation - Trucks $70,000 12 Accounts Payable $10,000 13. Cash $2.000 14 Wages Expense $40,000 15 Accounts Receivable + $70,000 16 Trucks $100,000 17 Gas Expense $20,000 10 Other equipment and tools $4.000 19 Rent Expense 524,000 20 21 Other information: 22 - Income for the previous 4 years oldest to most recent: 23 Year 4- $25,000; Year 3 $30,000; Year 2 - $50,000; Year 1 - $55,000 243% of the company's accounts receivable is considered uncollectible 25 - The market rate for rent for similar units is $2,200 per month The mechanic says the trucks are in good shape and should last at least another 3 years maintenance expenses should run $5,000 per season 2 A review of current contract shows one for the town municipal properties 29 for the past three years is ending and will not be renewed. The value of the contract was $30,000 per season 3 Conversations with Domenals the charges personal expenses to the company The amount is approximately 54.000 per season would 25% rate of return on hiavetinent 35 Cover Page for Excel Work T-Accounts and Trial Balance AGT2303 - Final Project - Excel Worksheets View Tell me Share General Insert V v 4.0 FO D Dalato $ % ) 8-98 Conditional Format Cell Formatting as Table Styles Format Sort & Filter Find & Select Analy Data H M 0 Cew the wood business in the bed Financial Statements Payroll Valuation MacBook Air Formatting as Table Styles Format M Calculate the value of Born's business using the asset-based Calculate the value of Bjorn's business using the samnings-based method. Excel Work T-Accounts and Trail Balance Financial Statements Payroll Valuation MacBook Air X Calibri (Body) v 11 ' " Paste I U V A N21 A 8 D E 3. Part 5: (a) Valuation for Purchase 4 5. The following information was pulled from a companies current annual financial statements Account Values 9 Depreciation Expencse - Trucks $10,000 10 Revenue $150,000 11 Accumulated Depreciation - Trucks $70,000 12 Accounts Payable $10,000 13 Cash $2,000 14 Wages Expense $40,000 15 Accounts Receivable $70,000 16 Trucks $100,000 17 Gas Expense $20,000 18 Other equipment and tools $4,000 19 Rent Expense $24,000 20 21 Other information: 22 Income for the previous 4 years oldest to most recent! 28 Year 4- $25,000; Year 3 -$30,000; Year 2 - $50,000, Year 1 - $55,000 24 3% of the company's accounts receivable is considered uncollectible 25 The market rate for rent for similar units is $2,200 per month 26. The mechanic says the trucks are in good shape and should last at least another 3 years 27 maintenance expenses should run $5,000 per season 28 review of current contracts shows one for the town municipal properties 229 for the past three years is ending and will not be renewed. 30 The value of the contract was $30,000 per season 31 Conversations with Bjorn reveals hecharges personal gas expenses to the company 2 the amount is approximately $4,000 per season Baker would likea 25 rate of return on his investment Cover Page for Excel Work T-Accounts and Trial Balance Financial Sta