In: Accounting
1) At Bradford Bed and Breakfast, the manager is looking to expand the facility. The following facts are known:
Cost of the expansion $2,200,000
The Manager is paid $99,000 per year. Compensation will not change due to the expansion
Property taxes will increase by $33,000 annually
The expansion will add 10 rooms and it is expected all 10 will be occupied by paying guests
The addition of the 10 guests each day is expected to add $800,000 of revenue annually
A garden and patio that was built last summer at a cost of $75,000 will be removed to make way for the expansion.
Additional cost of staff based on 10 occupied rooms is $260,000 annually
Additional cost of supplies and food based on 10 occupied rooms $80,000 annually
All expenses are expected to increase 3% annually. Due to competition revenue is expected to increase only 2% annually.
The useful life of the expansion is 8 years. Bradford uses a 8% discount rate.
Based on this information determine the following:
a. After the building is expanded, what is the incremental fixed cost incurred annually as a result of the expansion?
b. What are the incremental variable expense incurred annually due to the expansion?
c. What are the sunk costs of the expansion, if any?
d. Create an 8 year proforma cash flow statement for the expansion project (assume there are no income taxes)
e. Calculate the projects NPV and IRR. Should the project be accepted or rejected?
(A). Incremental Fixed Costs incurred annually as a result of the expansion | |||||||||||
$ | |||||||||||
Property Taxes | 33,000 | ||||||||||
Total | 33,000 | ||||||||||
(B). Incremental Variable Costs incurred annually as a result of the expansion | |||||||||||
$ | |||||||||||
Additional cost of staff | 2,60,000 | ||||||||||
Additional cost of supplies and food | 80,000 | ||||||||||
Total | 3,40,000 | ||||||||||
(C) Sunk costs of the Expansion | |||||||||||
$ | |||||||||||
Garden and patio | 75,000 | ||||||||||
(D) Proforma Cash Flow Statement | |||||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Remarks | |
Particulars | $ | $ | $ | $ | $ | $ | $ | $ | $ | ||
Cost of the Expansion | -22,00,000 | ||||||||||
Revenue | 8,16,000 | 8,32,320 | 8,48,966 | 8,65,946 | 8,83,265 | 9,00,930 | 9,18,949 | 9,37,328 | Inflation at 2% from Year 1 | ||
Expenses | |||||||||||
Property Taxes | 33,000 | 33,000 | 33,000 | 33,000 | 33,000 | 33,000 | 33,000 | 33,000 | |||
Additional cost of staff | 2,60,000 | 2,60,000 | 2,60,000 | 2,60,000 | 2,60,000 | 2,60,000 | 2,60,000 | 2,60,000 | |||
Additional cost of supplies and food | 80,000 | 80,000 | 80,000 | 80,000 | 80,000 | 80,000 | 80,000 | 80,000 | |||
Total of Expenses | 3,73,000 | 3,73,000 | 3,73,000 | 3,73,000 | 3,73,000 | 3,73,000 | 3,73,000 | 3,73,000 | |||
Total of Expenses (including the effect of inflation) |
3,84,190 | 3,95,716 | 4,07,587 | 4,19,815 | 4,32,409 | 4,45,382 | 4,58,743 | 4,72,505 | |||
Profit | 4,31,810 | 4,36,604 | 4,41,379 | 4,46,131 | 4,50,855 | 4,55,548 | 4,60,206 | 4,64,822 | |||
Discount Rate at 8% | 1 | 0.93 | 0.86 | 0.79 | 0.74 | 0.68 | 0.63 | 0.58 | 0.54 | ||
Present value of Cash Flows | -22,00,000 | 3,99,824 | 3,74,318 | 3,50,381 | 3,27,920 | 3,06,845 | 2,87,073 | 2,68,526 | 2,51,129 | ||
NPV at 8% | 3,66,014 | ||||||||||
IRR | r1+(NPV1/(NPV1-NPV2))*(r2-r1) | ||||||||||
where, | |||||||||||
r1 | =lower discount rate chosen |
Related SolutionsAt Bradford Bed and Breakfast, the manager is looking to expand the facility. The following facts...At Bradford Bed and Breakfast, the manager is looking to
expand the facility. The following facts are known:
Cost of the expansion $2,200,000
The Manager is paid $99,000 per year. Compensation will not
change due to the expansion
Property taxes will increase by $33,000 annually
The expansion will add 10 rooms and it is expected all 10 will
be occupied by paying guests
The addition of the 10 guests each day is expected to add
$800,000 of revenue annually
A...
BREAKEVEN ANALYSIS 6. You own a 10 bedroom Bed and Breakfast With the following, $ 12,000...BREAKEVEN ANALYSIS 6. You own a 10 bedroom Bed and Breakfast
With the following, $ 12,000 per month mortgage payment $ 4,000 per
month for the gardener and housekeeper $ 9.00 per room for soap,
towels etc. $ 20.00 per room desired Net Profit Assume a 30 day
month
SOLVE FOR THE FOLLOWING: a. The selling price per room per night
AND the monthly breakeven point. b. The monthly breakeven point if
you raise the selling price calculated in A...
You are the business development manager for Flipkart (India) which is now looking to expand in...You are the business development manager for Flipkart
(India) which is now looking to expand in Thailand. Based on the
Hofstede’s dimensions what would be some of the cultural challenges
in successfully running the business in Thailand?
Identify and justify any two major changes that Flipkart
will need to make in its business model prior to launching in
Thailand.
Prompt You are the Operations Manager for a technology company. Your company is looking to expand...Prompt
You are the Operations Manager for a technology
company. Your company is looking to expand its product line and in
doing so it will need a larger or even second location. What
considerations are taken into account for determining which
solution is best? When you decide the solution how do you secure
the property? Would any other item needed to expand the product
line be considered real property?
Suppose the owners of a new bed and breakfast establishment are interested in conducting an experiment...Suppose the owners of a new bed and breakfast establishment are
interested in conducting an experiment to determine effective
advertisement strategies for increasing the number of reservations.
The bed and breakfast owners intend to rotate advertisements for 12
weeks between a travel website, a travel magazine and a local
billboard. Customers making reservations will be asked if they saw
the advertisement. In this experiment, the independent variable has
how many levels?
A) 1
B) 2
C) 3
D) 4
E)...
Comfort Zone is a 60-bed, for-profit intermediate care facility in northern California. The reha-bilitative department manager,...Comfort Zone is a 60-bed, for-profit intermediate care facility
in northern California. The reha-bilitative department manager,
Jamie Richards, has been working at Comfort Zone for only 6months.
She holds monthly staff meetings, as well as additional individual
meetings with staff toaddress specific patient-related issues. On
most days, she eats lunch in a quiet corner of the cafe-teria so
that she can catch up on her paperwork at the same time.Catherine
Williams, one of her staff members who has been working...
With an initial outlay of $115,000, Goldie’s Retreat is researching an expansion of their bed-n-breakfast by...With an initial outlay of $115,000, Goldie’s Retreat is
researching an expansion of their bed-n-breakfast by offering a
Sunday brunch. The owner expects to see their money returned within
4 years and estimates an expected rate of return of 6%. With the
following projected free cash flows, should the owner proceed with
the investment? Use NPV and IRR to explain your
answer.
IO = -$115,000
FCF Year 1 =
$50,000
FCF Year 2 =
$25,000
FCF Year 3 =
$15,000 ...
Develop a marketing plan for a hypothetical Bed and Breakfast located in Atlanta, Georgia. To make...Develop a marketing plan for a hypothetical Bed and Breakfast
located in Atlanta, Georgia. To make the project flexible, you can
make all the necessary assumptions regarding the number of rooms,
occupancy rate, target market and price per room. Then based on
your assumptions, develop the Marketing Plan. Y
The Stone Lion, a bed and breakfast located in a sleepy town, caters to two groups...The Stone Lion, a bed and breakfast located in a
sleepy town, caters to two groups of customers, young couples
interested in something marginally more exotic than a staycation,
and corporate clients interested in doing some team-building at a
location with no cellular service. Corporations know they can get
rooms with minimal notice, but young couples on tight budgets tend
to plan well in advance of their planned stay at the property. The
corporate rate for rooms is $250 per...
Benoit is opening a bed and breakfast inn in a popular beach resort town. He hopes...Benoit is opening a bed and breakfast inn in a popular beach
resort town. He hopes to appeal to professional couples and
retirees who want a high-end beach vacation experience but with a
more home style experience – basically the experience of living in
a luxurious beach house but with all the amenities of a high end
hotel. Benoit’s B&B is directly on the beach and a few of the
rooms have ocean views and in the evenings, from the...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|