Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please can you solve the excel file and make sure that i can see the whole answer, sometimes we get the 1/2 pic of the
please can you solve the excel file and make sure that i can see the whole answer, sometimes we get the 1/2 pic of the image.
Exhibit 1, Master Budget Excel Exhibit 2, AirBnB Output Ex Master Budgets for Q1 and Q2, 2019 Month Q1 Total April January February March May June Q2 Total Revenue Rental Revenue Occupancy Days in Month Rental Days Average Nightly Rate Total Rental Revenue Cleaning Revenue Ave. Cleaning Rev./Night Total Cleaning Revenue Total Revenue 80% 31 25 $70.00 $1.750.00 80% 28 22 $70.00 $1.540.00 80% 31 25 $80.00 $2,000.00 80% 90 72 $73.47 $5.290.00 90% 30 27 $80.00 S2.160,00 90% 31 28 $90.00 $2.520.00 90% 30 27 590.00 $2.430,00 90% 91 82 $86.71 $7110.00 S15.00 $375.00 $2.125.00 $15.00 $330.00 $1.870.00 $15.00 $375.00 $2,375.00 $15.00 $1.080.00 $6,370.00 $15.00 $405.00 $2,565.00 $15.00 $420,00 $2.940.00 $15.00 $405.00 $2.835.00 $15.00 $1,230,00 $8,340.00 $15.00 $375.00 $15.00 $330.00 $15.00 $375.00 $15.00 $1,080.00 $15.00 $405.00 $15.00 $420,00 $15.00 $405.00 $15.00 $1.230.00 Expenses Variable Expenses Ave. Cleaning Cost/Night Total Variable Expenses Fixed Expenses Power Condo Fees Ave. Mortgage Interest Property Taxes Parking Banking Fees Maintenance Internet Total Fixed Expenses Total Expenses Operating Income $127.00 $127.00 $127.00 $381.00 $127.00 $154.30 $154.30 $154.30 S462.90 $154.30 $514.60 $S14.60 $514.60 S1,543.80 $514.60 $92.85 $92.85 $92.85 $278.55 $92.85 $103.50 $103.50 S103.50 $310.50 S103.50 $14.95 $14.95 $14.95 $44.85 $14.95 $200.00 $200.00 $200.00 $600,00 $200.00 563.25 $63.25 $63.25 $189.75 $63,25 $1,270.45 $1.270.45 $1,270,45 $3,811.35 $1,270.45 $1,645.45 $1,600.45 $1,645.45 $4,891.35 $1,675.45 $127.00 $127.00 $381.00 SI54.30 $154.30 $462.90 $514.60 $514.60 $1.543.80 $92.85 $92.85 $278.55 S103.50 $103.50 $310.50 $14.95 $14.95 $44.85 $200.00 $200.00 $600,00 $63.25 $63.25 $189.75 $1,270.45 $1,270.45 $3.811.35 $1,690.45 $1.675.45 $5,041.35 $479.55 $269.55 $729.55 S1,478.65 $889.55 $1,249.55 S1,159.55 $3,298.65 Exhibit 1, Master Budget Excel Exhibit 2, AirBnB Output Date Type 1/3/19 Reservation 1/11/19 Reservation 1/14/19 Reservation 1/17/19 Reservation 1/22/19 Reservation 1/29/19 Reservation 2/1/19 Reservation 2/6/19 Reservation 2/8/19 Reservation 2/11/19 Reservation 2/24/19 Reservation 2/26/19 Reservation 3/1/19 Reservation 3/5/19 Reservation 3/7/19 Reservation 3/9/19 Reservation 3/11/19 Reservation 3/14/19 Reservation 3/18/19 Reservation 3/23/19 Reservation 3/28/19 Reservation 3/30/19 Reservation 4/3/19 Reservation 4/11/19 Reservation 4/13/19 Reservation 4/16/19 Reservation 4/18/19 Reservation 4/20/19 Reservation 4/22/19 Reservation 4/24/19 Reservation 4/25/19 Reservation 5/1/19 Reservation 5/3/19 Reservation 5/4/19 Reservation 5/6/19 Reservation 5/9/19 Reservation S/10/19 Reservation 5/12/19 Reservation 5/17/19 Reservation 5/28/19 Reservation 5/30/19 Reservation 5/31/19 Reservation 6/3/19 Reservation 6/8/19 Reservation 6/22/19 Reservation Start Date Nights 12/19 1/10/19 1/13/19 1/16/19 1/21/19 1/28/19 1/31/19 2/5/19 2/7/19 2/10/19 2/23/19 2/25/19 2/28/19 3/4/19 3/6/19 3/8/19 3/10/19 313/19 3/17/19 3/22/19 3/27/19 3/29/19 42/19 4/10/19 4/12/19 4/15/19 4/17/19 4/19/19 4/21/19 4/23/19 4/24/19 4/30/19 52/19 5/3/19 5/5/19 5/8/19 5/9/19 5/11/19 5/16/19 5/27/19 5/29/19 5/30/19 62/19 67/19 621/19 Amount Cleaning Fee 4 320.1 50 3 271.6 50 2 151.32 50 4 320.1 50 6 455.9 50 3 252.2 SO 4 349.2 50 2 145.5 SO 3 271.6 50 13 323.41 SO 1 105.73 SO 3 220.19 SO 4 383.15 50 2 162.96 50 2 174.6 50 2 213.4 SO 3 237.65 50 4 388 30 5 388 50 2 188.18 50 2 1746 50 2 213.4 50 7 525.06 50 2 190.12 30 3 354.05 50 2 170.72 SO 2 203.7 50 2 221.16 50 2 170.72 50 1 109.61 30 6 397.7 SO 2 192.06 50 1 117.37 50 2 271.6 50 3 310.4 50 1 126.1 50 2 286.13 50 5 470.45 50 11 699.85 50 2 242.5 50 1 130.95 50 3 339.5 50 $ 611.1 14 1112.93 8 886.5 50 Exhibit 1, Master Budget Excel Exhibit 2, AirBnB Output Excel Exhibi Sales Volume Variance Static (Master) Budget Exhibit 3: Income Statement Performance Report Template Actual Flexible Flexible Budget Results Variance Budget Output U/F Total Revenue U/F Variable Expenses U/F Fixed Expenses U/F Total Expenses U/F Operating Income U/F U/F U/F U/F U/F U/F U/F Total Difference in Operating Income Exhibit 3: Expense Log Maintenance and Repairs February 6: Light and exterior door repair: $430.00 March 26: General house supplies: $35.62 April 24: Toilet repair: $184.00 Exhibit 4: Statistics Canada Short-Term Accommodation Table Total revenue of the private short-term accommodation market, by province and territory, 2015 to 2018 2015 2018 265,190 435 451 1,115 421 65,192 93,967 2016 2017 thousands of dollars 814,164 1,930,292 3,430 18,239 6,928 19.264 18,599 44.778 4,127 12.287 215,569 467.938 257,200 628,405 4,376 9.784 2,508 6,465 30,916 96,974 268,692 620,590 1,071 2,777 699 2,556 48 234 Canada Newfoundland and Labrador Prince Edward Island Nova Scotia New Brunswick Quebec Ontario Manitoba Saskatchewan Alberta British Columbia Yukon Northwest Territories Nunavut Note: Numbers may not add up to totale due to rounding The values are expressed in current dollars. Source: Statistics Canada, Special tabulation, 2019 2,760,023 29.406 29,768 70,870 20,510 634,588 909,421 16,052 11,208 151.929 876,080 4.678 4.797 715 1.538 836 8,818 92,020 308 77 10 Exhibit 1, Master Budget Excel Exhibit 2, AirBnB Output Ex Master Budgets for Q1 and Q2, 2019 Month Q1 Total April January February March May June Q2 Total Revenue Rental Revenue Occupancy Days in Month Rental Days Average Nightly Rate Total Rental Revenue Cleaning Revenue Ave. Cleaning Rev./Night Total Cleaning Revenue Total Revenue 80% 31 25 $70.00 $1.750.00 80% 28 22 $70.00 $1.540.00 80% 31 25 $80.00 $2,000.00 80% 90 72 $73.47 $5.290.00 90% 30 27 $80.00 S2.160,00 90% 31 28 $90.00 $2.520.00 90% 30 27 590.00 $2.430,00 90% 91 82 $86.71 $7110.00 S15.00 $375.00 $2.125.00 $15.00 $330.00 $1.870.00 $15.00 $375.00 $2,375.00 $15.00 $1.080.00 $6,370.00 $15.00 $405.00 $2,565.00 $15.00 $420,00 $2.940.00 $15.00 $405.00 $2.835.00 $15.00 $1,230,00 $8,340.00 $15.00 $375.00 $15.00 $330.00 $15.00 $375.00 $15.00 $1,080.00 $15.00 $405.00 $15.00 $420,00 $15.00 $405.00 $15.00 $1.230.00 Expenses Variable Expenses Ave. Cleaning Cost/Night Total Variable Expenses Fixed Expenses Power Condo Fees Ave. Mortgage Interest Property Taxes Parking Banking Fees Maintenance Internet Total Fixed Expenses Total Expenses Operating Income $127.00 $127.00 $127.00 $381.00 $127.00 $154.30 $154.30 $154.30 S462.90 $154.30 $514.60 $S14.60 $514.60 S1,543.80 $514.60 $92.85 $92.85 $92.85 $278.55 $92.85 $103.50 $103.50 S103.50 $310.50 S103.50 $14.95 $14.95 $14.95 $44.85 $14.95 $200.00 $200.00 $200.00 $600,00 $200.00 563.25 $63.25 $63.25 $189.75 $63,25 $1,270.45 $1.270.45 $1,270,45 $3,811.35 $1,270.45 $1,645.45 $1,600.45 $1,645.45 $4,891.35 $1,675.45 $127.00 $127.00 $381.00 SI54.30 $154.30 $462.90 $514.60 $514.60 $1.543.80 $92.85 $92.85 $278.55 S103.50 $103.50 $310.50 $14.95 $14.95 $44.85 $200.00 $200.00 $600,00 $63.25 $63.25 $189.75 $1,270.45 $1,270.45 $3.811.35 $1,690.45 $1.675.45 $5,041.35 $479.55 $269.55 $729.55 S1,478.65 $889.55 $1,249.55 S1,159.55 $3,298.65 Exhibit 1, Master Budget Excel Exhibit 2, AirBnB Output Date Type 1/3/19 Reservation 1/11/19 Reservation 1/14/19 Reservation 1/17/19 Reservation 1/22/19 Reservation 1/29/19 Reservation 2/1/19 Reservation 2/6/19 Reservation 2/8/19 Reservation 2/11/19 Reservation 2/24/19 Reservation 2/26/19 Reservation 3/1/19 Reservation 3/5/19 Reservation 3/7/19 Reservation 3/9/19 Reservation 3/11/19 Reservation 3/14/19 Reservation 3/18/19 Reservation 3/23/19 Reservation 3/28/19 Reservation 3/30/19 Reservation 4/3/19 Reservation 4/11/19 Reservation 4/13/19 Reservation 4/16/19 Reservation 4/18/19 Reservation 4/20/19 Reservation 4/22/19 Reservation 4/24/19 Reservation 4/25/19 Reservation 5/1/19 Reservation 5/3/19 Reservation 5/4/19 Reservation 5/6/19 Reservation 5/9/19 Reservation S/10/19 Reservation 5/12/19 Reservation 5/17/19 Reservation 5/28/19 Reservation 5/30/19 Reservation 5/31/19 Reservation 6/3/19 Reservation 6/8/19 Reservation 6/22/19 Reservation Start Date Nights 12/19 1/10/19 1/13/19 1/16/19 1/21/19 1/28/19 1/31/19 2/5/19 2/7/19 2/10/19 2/23/19 2/25/19 2/28/19 3/4/19 3/6/19 3/8/19 3/10/19 313/19 3/17/19 3/22/19 3/27/19 3/29/19 42/19 4/10/19 4/12/19 4/15/19 4/17/19 4/19/19 4/21/19 4/23/19 4/24/19 4/30/19 52/19 5/3/19 5/5/19 5/8/19 5/9/19 5/11/19 5/16/19 5/27/19 5/29/19 5/30/19 62/19 67/19 621/19 Amount Cleaning Fee 4 320.1 50 3 271.6 50 2 151.32 50 4 320.1 50 6 455.9 50 3 252.2 SO 4 349.2 50 2 145.5 SO 3 271.6 50 13 323.41 SO 1 105.73 SO 3 220.19 SO 4 383.15 50 2 162.96 50 2 174.6 50 2 213.4 SO 3 237.65 50 4 388 30 5 388 50 2 188.18 50 2 1746 50 2 213.4 50 7 525.06 50 2 190.12 30 3 354.05 50 2 170.72 SO 2 203.7 50 2 221.16 50 2 170.72 50 1 109.61 30 6 397.7 SO 2 192.06 50 1 117.37 50 2 271.6 50 3 310.4 50 1 126.1 50 2 286.13 50 5 470.45 50 11 699.85 50 2 242.5 50 1 130.95 50 3 339.5 50 $ 611.1 14 1112.93 8 886.5 50 Exhibit 1, Master Budget Excel Exhibit 2, AirBnB Output Excel Exhibi Sales Volume Variance Static (Master) Budget Exhibit 3: Income Statement Performance Report Template Actual Flexible Flexible Budget Results Variance Budget Output U/F Total Revenue U/F Variable Expenses U/F Fixed Expenses U/F Total Expenses U/F Operating Income U/F U/F U/F U/F U/F U/F U/F Total Difference in Operating Income Exhibit 3: Expense Log Maintenance and Repairs February 6: Light and exterior door repair: $430.00 March 26: General house supplies: $35.62 April 24: Toilet repair: $184.00 Exhibit 4: Statistics Canada Short-Term Accommodation Table Total revenue of the private short-term accommodation market, by province and territory, 2015 to 2018 2015 2018 265,190 435 451 1,115 421 65,192 93,967 2016 2017 thousands of dollars 814,164 1,930,292 3,430 18,239 6,928 19.264 18,599 44.778 4,127 12.287 215,569 467.938 257,200 628,405 4,376 9.784 2,508 6,465 30,916 96,974 268,692 620,590 1,071 2,777 699 2,556 48 234 Canada Newfoundland and Labrador Prince Edward Island Nova Scotia New Brunswick Quebec Ontario Manitoba Saskatchewan Alberta British Columbia Yukon Northwest Territories Nunavut Note: Numbers may not add up to totale due to rounding The values are expressed in current dollars. Source: Statistics Canada, Special tabulation, 2019 2,760,023 29.406 29,768 70,870 20,510 634,588 909,421 16,052 11,208 151.929 876,080 4.678 4.797 715 1.538 836 8,818 92,020 308 77 10 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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