Answered step by step
Verified Expert Solution
Link Copied!

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?

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Smith and Roberson Business Law

Authors: Richard A. Mann, Barry S. Roberts

15th Edition

1285141903, 1285141903, 9781285141909, 978-0538473637

Students also viewed these Finance questions