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
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