part 1 with info

part 2 with question

U OY U u 5 Overline Column Merge Cell 3- Insert Row Delete Column 3. DeleteRow Conditional Formatting - Conditions UICK HERE TO SAVE YOUR WORK H108 F G H B 20 outstanding 450000-46948.56 403051.44 71 12 Question 2-Working capital management (25 marks) 73 Solid property Inc. which owns several multifamily properties wants you to prepare the cash budget for April, May and June (second quarter) for 74 fiscal year 2021. 75 Rental income - 200 units at $800 per unit. 90% of rent is collected each month while the balance and the late collection fee are collected in 76 the following month. Late collection fee of 2.5% is applied on the balance. All the units will be fully occupled/rented out in April, in May. the occupancy rate will be 95%. Management intends to carry out major renovations in two of its properties in June which will affect 12 78 units. Notices have been sent to tenants in the two properties to vacate the residence by May 31 in order to do the renovation in June. The 79 that were vacant in May will still remain unoccupied in June. Cash generated from coin-operated washers and dryers and laundry supplies per month - $18,000 31 Mortgage payments made each month - $120,000 Purchase of laundry supplies and maintenance expense for each month is shown below: Laundry Supplies Maintenance expense April $5,000 $17.000 May $ 4,200 $ 15,000 June $ 3,800 $ 12,000 The laundry supplies are paid for each month. 50% of maintenance expense is paid for each month while the balance is paid a month after Marketing and advertising expense paid for each month - $3.500 Salaries paid to workers each month $12.000 Maintenance expense incurred each month - $17.000 91 Insurance expense for the third quarter paid in June - $9,000 Cost of renovation to be done and paid for in June Roof replacement $ 30,000 HVAC purchase $ 15,000 Flooring $6,500 Windows and new appliances 82 33 84 B 87 90 after 54 97 $ 15,000 C G C terbach Insert ColumnDelete Column Conditional Font Name - Font Size - TabStop Wrap Text BD AUS E Overline 13 Merge Cell 3. Insert Row + DeleteRow Paste Copy CUCK HERE TO SAVE YOUR WORK H100 H A D The laundry supplies are paid for each month. 50% of maintenance expense is paid for each month while the balance is paid a month af BB Marketing and advertising expense paid for each month - $3,500 89 Salaries paid to workers each month - $12,000 90 Maintenance expense incurred each month - $17,000. 91 after. 92 Insurance expense for the third quarter paid in June - $9,000 Cost of renovation to be done and paid for in June: Roof replacement $ 30,000 HVAC purchase $ 15,000 Flooring - $ 6,500 Windows and new appliances $ 15,000 Total $ 66,500 99 The company has a cash balance as of April 1, 2020 of $450,000 which is the minimum cash balance that the company wants to maintain 100 101 Required 102 Prepare a cash budget for April, May and June 2021 showing the surplus/deficit for each month. April 90% 144000 160000 balance 16000 Sales 2.SON 400 36 97 38 103 104 105 106 107 100 109 110 111 Trick U OY U u 5 Overline Column Merge Cell 3- Insert Row Delete Column 3. DeleteRow Conditional Formatting - Conditions UICK HERE TO SAVE YOUR WORK H108 F G H B 20 outstanding 450000-46948.56 403051.44 71 12 Question 2-Working capital management (25 marks) 73 Solid property Inc. which owns several multifamily properties wants you to prepare the cash budget for April, May and June (second quarter) for 74 fiscal year 2021. 75 Rental income - 200 units at $800 per unit. 90% of rent is collected each month while the balance and the late collection fee are collected in 76 the following month. Late collection fee of 2.5% is applied on the balance. All the units will be fully occupled/rented out in April, in May. the occupancy rate will be 95%. Management intends to carry out major renovations in two of its properties in June which will affect 12 78 units. Notices have been sent to tenants in the two properties to vacate the residence by May 31 in order to do the renovation in June. The 79 that were vacant in May will still remain unoccupied in June. Cash generated from coin-operated washers and dryers and laundry supplies per month - $18,000 31 Mortgage payments made each month - $120,000 Purchase of laundry supplies and maintenance expense for each month is shown below: Laundry Supplies Maintenance expense April $5,000 $17.000 May $ 4,200 $ 15,000 June $ 3,800 $ 12,000 The laundry supplies are paid for each month. 50% of maintenance expense is paid for each month while the balance is paid a month after Marketing and advertising expense paid for each month - $3.500 Salaries paid to workers each month $12.000 Maintenance expense incurred each month - $17.000 91 Insurance expense for the third quarter paid in June - $9,000 Cost of renovation to be done and paid for in June Roof replacement $ 30,000 HVAC purchase $ 15,000 Flooring $6,500 Windows and new appliances 82 33 84 B 87 90 after 54 97 $ 15,000 C G C terbach Insert ColumnDelete Column Conditional Font Name - Font Size - TabStop Wrap Text BD AUS E Overline 13 Merge Cell 3. Insert Row + DeleteRow Paste Copy CUCK HERE TO SAVE YOUR WORK H100 H A D The laundry supplies are paid for each month. 50% of maintenance expense is paid for each month while the balance is paid a month af BB Marketing and advertising expense paid for each month - $3,500 89 Salaries paid to workers each month - $12,000 90 Maintenance expense incurred each month - $17,000. 91 after. 92 Insurance expense for the third quarter paid in June - $9,000 Cost of renovation to be done and paid for in June: Roof replacement $ 30,000 HVAC purchase $ 15,000 Flooring - $ 6,500 Windows and new appliances $ 15,000 Total $ 66,500 99 The company has a cash balance as of April 1, 2020 of $450,000 which is the minimum cash balance that the company wants to maintain 100 101 Required 102 Prepare a cash budget for April, May and June 2021 showing the surplus/deficit for each month. April 90% 144000 160000 balance 16000 Sales 2.SON 400 36 97 38 103 104 105 106 107 100 109 110 111 Trick