Reference no: EM13204975
The owner of Lazy Inn has been requested by First National Bank to submit a cash budget for the next calendar year. With that in mind, please prepare the following:
a 12-month projected cash budget statement for 2012 (assume that your beginning cash (Jan 1) is $16,500).
After preparing the above schedule, can you provide the owner with some guidance as to whether:
to raise Lazy Inns summer (June-Aug) rates by 10% across the board. The owners guess is that occupancy would go down by 5 percentage points if the rates were raised. What would the impact on cumulative borrowing be if these rates did change? (use scenario manager)
Cash Inflows
Room
QtyJan-Mar & Dec. Price/Occupancy RateApr-May Price/Occupancy RateJune-Aug Price/Occupancy RateSept.-Nov. Price/Occupancy Rate
1 king size bed/room10$58 / 85%$40 / 50%$58 / 75%$45 / 55%
2 king size beds/room60$70 / 80%$48 / 55%$70 / 80%$50 / 58%
2 bedroom (2 kings/room)20$80 / 78%$60 / 40%$80 / 88%$64 / 60%
10 executive suites 10$120 / 95%$90 / 45%$120 / 100%$95 / 65%
On your cash budget, be sure to show each room types cash flow individually (and total for all rooms by month)
Vending machines:$200/monthly -> Jan-Mar, Sept.- Dec.; $320/monthly (Apr - Aug) Revenue is collected in the month of sale.
Conference Room rental rate = $150 daily (Jan - May, Sept - Dec); $180 daily (June - Aug.) occupancy rate (25% of days in Jan - May, Sept - Dec; 35% of the days in June - Aug) -- Revenue is collected in the month of the rental.
For the room revenue, 30% are cash sales; 70% are credit sales. Of the credit sales, 40% of the credit sales are collected in the month of sale while 25% are collected one month later; the balance two months later. Total room revenue for November and December of 2011 was 115,000 and 185,000, respectively.
Cash Outflows
Mortgage ($12,000/monthly)
Payroll expenses (Jan. - May, Sept - Dec. = $135,000/monthly; June - Aug. = $150,000/monthly )
Insurance (quarterly payments of $9,300 on March 1, June 1, Sept. 1, and Dec. 1)
Utilities (Jan - Mar, Nov. - Dec. = $3,900/month; Apr. - Oct = $2,900/month)
Professional Services ($1,900/month)
Bonus to Desk Manager ($400/monthly if monthly room revenues > $180,000 for Jan - May, Sept. - Dec.; > $195,000 for June - Aug.)
You want to maintain at least $15,000 in your bank account. Any balance less than $15,000 you need to borrow from your line of credit.
What is the highest cumulative amount that needs to be borrowed during this 12 month period? Use the roundup function to round this amount to the highest thousand dollar amount.
|
Calculate the standard deviation of the return
: Suppose that an investor has a choice between buying this security or purchasing a different security that also costs $3,000 today but pays off $3,300 with certainty in one year. How is an investor's choice of which security to purchase related to..
|
|
State the addition of bromine to cinnamic acid
: Based on the stereochemistry of the addition of bromine to cinnamic acid, write structure of the dibromide product(s) that you think will be formed as the result of the reaction of Z-2-pentene with bromine
|
|
Find a quadratic equation
: Explain. Provide your classmate's with one or two solutions with which they must create a quadratic equation.
|
|
State the total mass of the mixture
: dissolve CaCl2 in water to make a mixture that is 34.0% calcium chloride by mass. If the total mass of the mixture is 222.3 g, what masses of CaCl2 and water should be used?
|
|
Submit a cash budget for the next calendar year
: What is the highest cumulative amount that needs to be borrowed during this 12 month period? Use the roundup function to round this amount to the highest thousand dollar amount.
|
|
Compute the ph in the titration
: Calculate the pH for each of the following cases in the titration of 50.0 mL of 0.120 M HClO(aq) with 0.120 M KOH(aq).
|
|
How did the wall street reform and consumer protection act
: Are there more or fewer banks today than before the start of the financial crisis of 2007-2008 Why are the lines between the categories of financial firms even more blurred than they were before the crisis
|
|
Estimate the time of death
: Newton's Law of Cooling states that the rate of change of the temperature of an object is proportional to the difference between the temperature of the object and the temperature of the environment.
|
|
Compute the equilibrium molar concentrations of hg
: Calculate the equilibrium molar concentrations of Hg2+ and SCN- in a solution prepared by mixing 10 mL of 0.0200 M Hg2+ with 10 mL of 0.0200 M SCN
|