Instructions in the excel

Assignment
    Fina-3048         Fall 2020 Budgeting Assignment-Tumble Weed Inn
    Due Date:            Thursday October 29/20 by: 11:59pm
                The assignment will be graded out of 90 points
    Use the following information to prepare the Operating Budget, to include
    the full calculation of the rooms revenue using the double differential formula and
    expenses forecast. Once you have completed the Operating Budget, you will be
    able to prepare a Cash Flow Budget
    The Tumble Weed Inn has 10 rooms and it is open year round.
    However, the motel is closed for 15 days of vacation between seasons.
    It has no food or beverage facilities. We'll assume you would like to achieve
    a net after-tax income of approximately $50,000 for the year, which is a 10%
    return on equity of $500,000
    The division of your budget into planning periods are best defined as
     May 1 - October 31 and November 1 - April 30 since the Tumble Weed Inn
     is located in a summer tourist area.
    Some of the factors and trends expected to affect your business:
    The Tumble Weed Inn has been in business for 10 years and has
    developed a solid relationship with repeat guests. You do not
    anticipate any major changes in demand by this market. However,
    a local motor-inn of comparable facilities has just gone out of business.
    As a result, you feel your annual occupancy should increase by 5%.
    The local economy is stable. However, you expect a general
    increase in prices of 8%. Some rooms will require small renovations,
    $20,000 will be spent in June and $17,000 will be spent in December.
    Your marketing budget is $5000 which will be spent eqully throughout the season
    Administrative and general expenses are estimated at $ 2700 for May- Oct.
    and $2650 for Nov - April
    Estimate Telephone revenues at $2.50 per occupied room night and Other income
    at 1% of rooms reveunes. The owners withdrew $15,500 semi annually as drawings
    from the business and managed to repay $1,200 monthly in debt to the local...