Oct 16, 2017 term paper 2

Prepare the first six (6) months of Miranda’s A cash budget

This paper concentrates on the primary theme of Prepare the first six (6) months of Miranda’s A cash budget in which you have to explain and evaluate its intricate aspects in detail. In addition to this, this paper has been reviewed and purchased by most of the students hence; it has been rated 4.8 points on the scale of 5 points. Besides, the price of this paper starts from £ 40. For more details and full access to the paper, please refer to the site.

Calculation and discussion

 The construction of cash budget for a new hotel

Miranda has £2,000,000 available to invest in a new airport hotel which she will open on 1 April 20X1. The hotel caters for conferences and events as well as the normal airport trade of tourists, air crews and business travellers. Miranda has £125,000 in cash.

She has made the following forecasts

The hotel will have 30 rooms and will be open for dinner seven days a week.

Average monthly occupancy levels are expected to be:

April                                            20%

May                                             30%

June                                           50%

July                                             80%

August                                       90%

September                               60%

 

Average spend is expected to be £150 per room per night and 30% of sales are expected to be for cash and 70% of sales are expected to be on credit. Credit sales are expected to be paid within 2 months.

Monthly purchases of food, drink, laundry materials are expected to be 20% of sales. 80% of these purchases will be on credit and 20% in cash. It is planned to pay creditors in the month after the purchase takes place.

Labour cost is budgeted at 20% of sales and will be paid in the same month.

Overhead costs are budgeted at 25% of sales and will be paid with a time lag of one month

 

Task 1

1.Prepare the first six (6) months of Miranda’s A cash budget

2.Discuss any reservations you have about the information that you have prepared.

Task 2

A main shareholder argues that if the hotel does not offer the initial investment back within five (5) years, it is not a good investment for her.

a.Argue against the method used by this shareholder.

b.Discuss other methods which could be used to appraise this investment and calculate NPV for Miranda. Assume the following:

  • Discount rate of 10%.
  • Net cash inflow at the end of year 1 is £250,000
  • Net cash flow will grow 3% year on year.
  • Miranda hopes to sell the business on her retirement after 10 years for £3,000,000.

0% Plagiarism Guaranteed & Custom Written, Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

Order Now

STILL NOT CONVINCED?

We've produced some samples of what you can expect from our Academic Writing Service - these are created by our writers to show you the kind of high-quality work you'll receive. Take a look for yourself!

View Our Samples

corona virus stop
FLAT 25% OFF ON EVERY ORDER.Use "FLAT25" as your promo code during checkout