05 Jun THE FINAL PROJECT (TO be submitted via an Excel attachment and
Question
WEEK 6 FIN571
THE FINAL PROJECT (TO be submitted via an Excel attachment and Word Document)
You are the executive officers of Big Buns, Inc. (BBI). BBI manufactures different types of chairs and accessories. You have had several good years and have decided to expand. BBI is looking at acquiring another company as a subsidiary.
As executives (financially savvy and adept in capital budgeting procedures :-)) you have narrowed your choices to two possible acquisitions; Hineys R Us, a seat cushion manufacturer, and Flaberific, a heavy duty lawn chair manufacturer. You only have $500,000 to spend, which happens to be the price tag for each of the companies. It is your job to determine which company you should acquire.
BBI’s cost of capital is 10%.
The raw data for each company is as follows:
Hineys R Us (HRU)
—————–
HRU is projected to sell 50,000 units (seat cushions) in year one at a retail price of $15 per unit with an increase of 30% per year.
Variable costs consist of Cost of goods sold, estimated at 25% of sales; advertising, estimated at 10% of sales; other variable costs, estimated at 5% of sales.
Fixed costs consist of labor for year one estimated at $200,000 with an increase of 10% per year; rent for year one estimated at $60,000 with an increase of 5% per year; depreciation estimated at $10,000 per year; and other fixed costs for year one estimated at $5,000 with an increase of 5% per year.
HRU’s tax rate is estimated at 30%.
You also project that you will have to spend an additional $20,000 in year 2 and $50,000 in year 5 in capital expenditures.
To be conservative you are using a discount rate 2 points above BBI’s cost of capital.
Flaberific (FLB)
—————-
FLB is projected to sell 40,000 units (lawn chairs) in year one at a retail price of $25 per unit with an increase of 30% per year.
Variable costs consist of Cost of goods sold, estimated at 30% of sales; advertising, estimated at 15% of sales; other variable costs, estimated at 5% of sales.
Fixed costs consist of labor for year one estimated at $250,000 with an increase of 10% per year; rent for year one estimated at $80,000 with an increase of 5% per year; depreciation estimated at $20,000 per year; and other fixed costs for year one estimated at $5,000 with an increase of 5% per year.
FLB’s tax rate is estimated at 30%.
You also project that you will have to spend an additional $75,000 in year 2 and $175,000 in year 5 in capital expenditures.
You consider FLB to be slightly more risky than HRU so you will use a discount rate 3 points above BBI’s cost of capital.
**************WHAT IS REQUIRED***************** MS Excel
For both companies (HRU and FLB):
1) A 5 year projected Income Statement.
2) A 5 year projected Cash Flow.
3) Net Present Value
4) Internal Rate of Return
5) Payback Period
6) Profitability Index
7) Discounted Payback
8) Modified Internal rate of Return
9) Breakeven for year 1
MS Word 10) Based on items 1 through 7, write a minimum 500 word paper (APA Format) regarding which company should acquire BBI and the reasons why.
Tutorials for this Question
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.