Please make a table (screenshot is fine) and Estimated cash budget for the ending year (monthly and annual cash budgets)

The Chinese music instrument store is located near Richmond centre, BC, Canada.

Products:

Percussion Instruments

Gu - $200

Kuai ban - $50

Wind Instrument

Xiao - $350

Dizi - $400

String Instrument

Chinese Fiddle- $600

Pipa - $700

Service:

Rental Instrument

per hour including place minimum 30 days.

Gu/drum - $2.99

Kuai ban - $0.99

Xiao -$4.99

Dizi -$4.99

Chinese Fiddle -$6.99

Pipa -$7.99

You can use the sample: https://drive.google.com/file/d/1Q2fBKyA_1_XFFitt0PcLF9PR1woGhndh/view?usp=sharing

This is an example:

Cash Budget May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr Total Beginning Cash Balance $10,000.00 $68,959.77 $70,766.22 $72,402.80 $74,217.10 $74,330.19 $74,254.89 $74,351.86 $76,143.19 $75,121.24 $74,314.40 $73,508.56 $10,000.00 + Cash Collections 21,254.33 23,614.25 23,614.25 23,614.25 21,254.33 21,254.33 21,254.33 23,614.25 20,044.39 20,044.39 20,044.39 20,044.39 259,651.88 Total Cash Available 31,254.33 92,574.02 94,380.47 96,017.05 95,471.43 95,584.52 95,509.22 97,966.11 96,187.58 95,165.63 94,358.79 93,552.95 269,651.88 Cash Disbursements: Less Cash Disbursements: For Inventory Purchases 479.20 461.23 449.25 449.25 389.35 401.33 401.33 461.23 347.42 365.39 365.39 365.39 4,935.76 For Capatial Purchase 2,129.77 2,129.77 Start up Cost 28,768.76 28,768.76 Salary 13,007.80 13,007.80 13,007.80 13,007.80 13,007.80 13,007.80 13,007.80 13,007.80 13,007.80 13,007.80 13,007.80 13,007.80 156,093.60 Rent 4,943.00 4,943.00 4,943.00 4,943.00 4,943.00 4,943.00 4,943.00 4,943.00 4,943.00 4,943.00 4,943.00 4,943.00 59,316.00 Supply Purchase 9,765.90 9,765.90 Tool Purchase 645.76 645.76 Office Supply purchase 117.33 117.33 Utility 246.79 238.32 234.08 217.14 936.33 Other Fixed 409.04 507.04 507.04 507.04 507.04 507.04 507.04 507.04 507.04 507.04 507.04 507.04 5,986.48 Income Tax 860.73 796.79 865.86 266.06 204.14 271.19 875.85 4,140.61 Total Cash Disbursement 60,266.56 19,779.80 19,950.67 19,772.95 19,113.25 19,301.63 19,130.36 19,794.92 19,039.34 18,823.23 18,823.23 19,040.37 272,836.30 Excess (deficiency ) of Ca -29,012.23 72,794.22 74,429.80 76,244.10 76,358.19 76,282.89 76,378.86 78,171.19 77,148.24 76,342.40 75,535.56 74,512.58 3,184.42 Financing Total Borrowing 100,000.00 $100,000.00 Principal Repyaments 1,361.00 1,370.00 1,379.00 1,388.00 ,398.00 .407.00 1,416.00 1,426.00 1,435.00 1,445.00 ,454.00 1,464.00 $16,943.00 Interest Payments 567.00 658.00 648.00 639.00 630.00 621.00 611.00 602.00 592.00 583.00 573.00 563.00 $7,387.00 Total Cash From Financing 83,057.00 Ending Cash Balance $68,959.77 $70,766.22 $72,402.80 $74,217.10 $74,330.19 $74,254.89 $74,351.86 $76,143.19 $75,121.24 $74,314.40 $73,508.56 $72,485.58 $72,485.58