Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored 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

Fair Value Measurement Practical Guidance And Implementation

Authors: Mark L. Zyla

3rd Edition

1119191238, 9781119191230

More Books

Students also viewed these Accounting questions

Question

Graph the first-octant portion of each plane. 5x + 2y = 10

Answered: 1 week ago

Question

Describe the major barriers to the use of positive reinforcement.

Answered: 1 week ago