Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Make a new income statement, balance sheet, cash flow, and shareholder's equity if the capital and the equity of the company is financed by debt.
Make a new income statement, balance sheet, cash flow, and shareholder's equity if the capital and the equity of the company is financed by debt. And will the company be able to pay it in return?
Table 4.18 Statement of Financial Position Techno-Harmonix Lights and Sound Rental and Event Services Statement of Financial Position 5-year Projection Pre- Operating Expenses Year 1 Year 2 Year 3 Year 4 Year 5 1,521,994.85 2,173,484.60 2,936,486.18 3,840,905.59 1,521,994.85 2,173,484.60 2,936,486.18 3,840,905.59 4,896,042 88 4,896,042.88 6,112,792 20 6,112,792.20 Asset Current Asset Cash Total Current Asset Non-Current Asset Building Improvement-net book value Acc. Dep.- Building Improvement Light, Sound, Tools and Equipment Acc. Dep.- Light and Sound Equip. Service Vehicle Acc. Dep.- Service Vehicle Fumiture and Fixtures Acc. Dep.- Furniture and Fixtures Office Equipment Acc. Dep.- Office Equipment Fire Extinguisher Tank Acc. Dep.- Fire Extinguisher Tank Total Non-Current Asset Total Asset Liability and Partners' Equity Partners' Equity Beginning Balance Income this period Total Liability and Partners' Equity 600.000.00 600,000.00 600,000.00 600.000.00 (60,000.00) (120,000.00) (180,000.00) 2,518,347.40 2,518,347.40 2,518,347.40 2,518,347.40 (251,834.74) (503,669.48) (755,504 22) 800,000.00 800,000.00 800,000.00 800,000.00 (80,000.00) (160,000.00) (240,000.00) 8,167.75 8,167.75 8,167.75 8,167.75 (1,633.55) (3,267.10) (4,900.65) 46,490.00 46,490.00 46,490.00 46,490.00 (4,649.00) (9,298.00) (13,947.00) 5,000.00 5,000.00 5,000.00 5,000.00 (1,000.00) (2,000.00) (3,000.00) 3,978,005.15 3,578,887.86 3,179,770.57 2,780,653.28 5,500,000.00 5,752,372.46 6,116,256.756,621,558.87 600.000,00 800.000.00 (240,000.00 (300,000.00 2,518,347.40 2,518,347 40 (1,007,338.96) (1.259,173.70) 800,000.00 800,000.00 (320,000.00) (400,000.00) 8,167.75 8,167.75 (6,534 20 (8.167.75) 46,490.00 46,490.00 (18,596.00) (23,245.00) 5,000.00 5,000.00 (4.000.00) (5,000.00) 2,381,535.99 1,982,418.70 7,277,578.87 8,095,210.90 5,500,000.00 5,500,000.00 5,500,000.00 5,500,000.00 252,372.46 616,256.75 252,372.46 363,884.28 505,302.12 5,500,000.00 5,752,372.46 6,116,256.75 6,621,558.87 5,500,000.00 1,121,558.87 656,020.00 7,277,578.87 5,500,000.00 1,777,578.87 817,632.03 8,095,210.90 Techno-Harmonix Lights and Sound Rental and Event Services Statement of Financial Performance 5-year Projection Year 1 Year 2 Year 3 Year 4 Year 5 1,536,000.00 1,684,000.00 1,862,000.00 2,048,000.00 2,246,000.00 337,800.00 371,950.00 406,100.00 446,250.00 490,550.00 1,873,800.00 2,055,950.00 2,268,100.00 2,494,250.00 2,736,550.00 9,462.00 9,935.10 10,431.86 10,953.45 11,501.12 30,720.00 33,680.00 37,240.00 40,960.00 44,920.00 50,761.92 53,300.02 55,965.02 58,763.27 61,701.43 15,036.00 15,787.80 16,577.19 17,406.05 18,276.35 11,538.00 12,114.90 12,720.65 13,356.68 14,024.51 117,517.92 124,817.82 132,934.72 141,439.45 150,423.41 1,756,282.08 1,931,132.18 2,135,165.28 2,352,810.55 2,586,126.59 Service Revenue Commission from Additional Services Total Income Less Variable Cost Office Supplies Expense Repairs and Maintenance Utilities Expense Miscellaneous Expense Tools and Gear Acc. Expense Total Variable Cost Contribution Margin Less Fixed Cost Depreciation Expense Employees Salary and Other Benefits Rent Expense Permits and Licenses Promotional Expense Total Fixed Cost Total Expenses Net Income before Tax Tax Due: Multiplied by Tax Rate Net Income after tax 399,117.29 399,117.29 399,117.29 399,117.29 399,117.29 860,551.20 860,561.20 860,551.20 860,551.20 860,551.20 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 6,031.50 19,376.50 20,856.50 22,636.50 24,496.50 10,050.00 10,552.50 11,080.13 11,634.13 12,215.84 1,395,749.99 1,409,597.49 1,411,605,12 1,413,939.12 1,416,380.83 1,513,267.91 1,536,115.31 1,546,239.82 1,557,078.57 1,568,504.24 360,532.09 519,834.69 721,860.18 937,171.43 1,168,045.76 108, 159.63 252,372.46 155,950.41 363,884.28 216,558.05 505,302.12 281,151.43 656,020.00 350,413.73 817,632.03 Table 4.20 Statements of Cash Flow Techno-Harmonix Lights and Sound Rental and Event Services Statement of Cash Flow 5-year Projection Pre-Operating Period Year 1 Year 2 Year 3 Year 4 Year 5 Cash Flow from Operating Activities Net Income After Tax Add: Depreciation Expense Net Cash Flow from Operating Activities 252 372.46 399,117.29 363,884.28 399,117.29 505,302.12 399,11729 856,020.00 399,117 29 817,632.03 399.117 29 651,489.75 763,001.57 904,419.41 1,055,137.29 1,216,749.32 Cash Flow from Investing Building Improvement Lights and Sound Equipment Service Vehicle (600,000.00) 2518,347.40) (800,000.00) Fumitures and Fixtures (8.167.75) Office Equipment (46,490.00) Fire Extinguisher Tank Net Cash Flow from Investing (5,000.00) (3,978,005.15) Cash Flow from Financing Activities Initial Investment Net Cash Flow Provided from Financing Activities 5,500,000.00 5,500,000.00 1,521,994.85 Net Increase (Decrease) in Cash Add: Cash Balance Beginning Cash Balance Ending 651,489.75 1,521,994.85 2,173,484.60 763,001.57 2,259,537.81 2,936,486.18 904,419.41 2,936,486.18 3,840,905.59 1,055,137.29 3,840,905.59 4,896,042.88 1,216,749.32 4,896,042.88 6,112,792.20 1,521,994.85 Table 4.18 Statement of Financial Position Techno-Harmonix Lights and Sound Rental and Event Services Statement of Financial Position 5-year Projection Pre- Operating Expenses Year 1 Year 2 Year 3 Year 4 Year 5 1,521,994.85 2,173,484.60 2,936,486.18 3,840,905.59 1,521,994.85 2,173,484.60 2,936,486.18 3,840,905.59 4,896,042 88 4,896,042.88 6,112,792 20 6,112,792.20 Asset Current Asset Cash Total Current Asset Non-Current Asset Building Improvement-net book value Acc. Dep.- Building Improvement Light, Sound, Tools and Equipment Acc. Dep.- Light and Sound Equip. Service Vehicle Acc. Dep.- Service Vehicle Fumiture and Fixtures Acc. Dep.- Furniture and Fixtures Office Equipment Acc. Dep.- Office Equipment Fire Extinguisher Tank Acc. Dep.- Fire Extinguisher Tank Total Non-Current Asset Total Asset Liability and Partners' Equity Partners' Equity Beginning Balance Income this period Total Liability and Partners' Equity 600.000.00 600,000.00 600,000.00 600.000.00 (60,000.00) (120,000.00) (180,000.00) 2,518,347.40 2,518,347.40 2,518,347.40 2,518,347.40 (251,834.74) (503,669.48) (755,504 22) 800,000.00 800,000.00 800,000.00 800,000.00 (80,000.00) (160,000.00) (240,000.00) 8,167.75 8,167.75 8,167.75 8,167.75 (1,633.55) (3,267.10) (4,900.65) 46,490.00 46,490.00 46,490.00 46,490.00 (4,649.00) (9,298.00) (13,947.00) 5,000.00 5,000.00 5,000.00 5,000.00 (1,000.00) (2,000.00) (3,000.00) 3,978,005.15 3,578,887.86 3,179,770.57 2,780,653.28 5,500,000.00 5,752,372.46 6,116,256.756,621,558.87 600.000,00 800.000.00 (240,000.00 (300,000.00 2,518,347.40 2,518,347 40 (1,007,338.96) (1.259,173.70) 800,000.00 800,000.00 (320,000.00) (400,000.00) 8,167.75 8,167.75 (6,534 20 (8.167.75) 46,490.00 46,490.00 (18,596.00) (23,245.00) 5,000.00 5,000.00 (4.000.00) (5,000.00) 2,381,535.99 1,982,418.70 7,277,578.87 8,095,210.90 5,500,000.00 5,500,000.00 5,500,000.00 5,500,000.00 252,372.46 616,256.75 252,372.46 363,884.28 505,302.12 5,500,000.00 5,752,372.46 6,116,256.75 6,621,558.87 5,500,000.00 1,121,558.87 656,020.00 7,277,578.87 5,500,000.00 1,777,578.87 817,632.03 8,095,210.90 Techno-Harmonix Lights and Sound Rental and Event Services Statement of Financial Performance 5-year Projection Year 1 Year 2 Year 3 Year 4 Year 5 1,536,000.00 1,684,000.00 1,862,000.00 2,048,000.00 2,246,000.00 337,800.00 371,950.00 406,100.00 446,250.00 490,550.00 1,873,800.00 2,055,950.00 2,268,100.00 2,494,250.00 2,736,550.00 9,462.00 9,935.10 10,431.86 10,953.45 11,501.12 30,720.00 33,680.00 37,240.00 40,960.00 44,920.00 50,761.92 53,300.02 55,965.02 58,763.27 61,701.43 15,036.00 15,787.80 16,577.19 17,406.05 18,276.35 11,538.00 12,114.90 12,720.65 13,356.68 14,024.51 117,517.92 124,817.82 132,934.72 141,439.45 150,423.41 1,756,282.08 1,931,132.18 2,135,165.28 2,352,810.55 2,586,126.59 Service Revenue Commission from Additional Services Total Income Less Variable Cost Office Supplies Expense Repairs and Maintenance Utilities Expense Miscellaneous Expense Tools and Gear Acc. Expense Total Variable Cost Contribution Margin Less Fixed Cost Depreciation Expense Employees Salary and Other Benefits Rent Expense Permits and Licenses Promotional Expense Total Fixed Cost Total Expenses Net Income before Tax Tax Due: Multiplied by Tax Rate Net Income after tax 399,117.29 399,117.29 399,117.29 399,117.29 399,117.29 860,551.20 860,561.20 860,551.20 860,551.20 860,551.20 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 6,031.50 19,376.50 20,856.50 22,636.50 24,496.50 10,050.00 10,552.50 11,080.13 11,634.13 12,215.84 1,395,749.99 1,409,597.49 1,411,605,12 1,413,939.12 1,416,380.83 1,513,267.91 1,536,115.31 1,546,239.82 1,557,078.57 1,568,504.24 360,532.09 519,834.69 721,860.18 937,171.43 1,168,045.76 108, 159.63 252,372.46 155,950.41 363,884.28 216,558.05 505,302.12 281,151.43 656,020.00 350,413.73 817,632.03 Table 4.20 Statements of Cash Flow Techno-Harmonix Lights and Sound Rental and Event Services Statement of Cash Flow 5-year Projection Pre-Operating Period Year 1 Year 2 Year 3 Year 4 Year 5 Cash Flow from Operating Activities Net Income After Tax Add: Depreciation Expense Net Cash Flow from Operating Activities 252 372.46 399,117.29 363,884.28 399,117.29 505,302.12 399,11729 856,020.00 399,117 29 817,632.03 399.117 29 651,489.75 763,001.57 904,419.41 1,055,137.29 1,216,749.32 Cash Flow from Investing Building Improvement Lights and Sound Equipment Service Vehicle (600,000.00) 2518,347.40) (800,000.00) Fumitures and Fixtures (8.167.75) Office Equipment (46,490.00) Fire Extinguisher Tank Net Cash Flow from Investing (5,000.00) (3,978,005.15) Cash Flow from Financing Activities Initial Investment Net Cash Flow Provided from Financing Activities 5,500,000.00 5,500,000.00 1,521,994.85 Net Increase (Decrease) in Cash Add: Cash Balance Beginning Cash Balance Ending 651,489.75 1,521,994.85 2,173,484.60 763,001.57 2,259,537.81 2,936,486.18 904,419.41 2,936,486.18 3,840,905.59 1,055,137.29 3,840,905.59 4,896,042.88 1,216,749.32 4,896,042.88 6,112,792.20 1,521,994.85
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started