Question: Calculate the depreciable value of the project You have determined in your mind that you would like to have a business of your own, although your  father runs a family restaurant in your local city. You have therefore, decided to have a medium  size snack and cocktails bar which will accommodate the cruise ship passengers who visit your city.  You plan to keep the business for five years after which you will sell it off to your brother John  for $2,000,000 and go off to do your Master’s Degree in the UK. Though you will be occupying the  establishment from your grandmother for free, you have decided that you need to make some  improvements to the property which will cost you $1,500,000. Additionally, you will spend $275,000  in bar stools, tables and decorations. If this space had been leased out, it would have fetched a  lease rental of $75,000 per year. You will depreciate the assets over 7 years using MACRS. You have  determined that you would need an average cash balance of $15,000 and inventory of $20,000 while  Accounts payable should average $10,000. You plan to borrow the money from a local bank and pay  interest at a rate of 15 percent. To increase your chances of success at the business you plan to  have your cousin Johnathan to conduct a market survey which will cost you $100,000. Your new  venture will decrease the revenue your family business will earn by $15,000 per year and you have  agreed to allow your father to take this amount from your allowance as a shareholder of the family  restaurant. Revenues are projected to be $500,000 the first year and is expected to increase by 20% the second  year, 15% the third year and to continue to increase at 10% thereafter. Fixed annual operating  costs are expected to be salaries of $110,000, Utilities $75,000, Food and Liquor License is 15% of  gross revenues and taxes are 40% of net revenues.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter26: Capital Budgeting (capbud)
Section: Chapter Questions
Problem 5R
icon
Related questions
Question

Question: Calculate the depreciable value of the project

You have determined in your mind that you would like to have a business of your own, although your 
father runs a family restaurant in your local city. You have therefore, decided to have a medium 
size snack and cocktails bar which will accommodate the cruise ship passengers who visit your city. 
You plan to keep the business for five years after which you will sell it off to your brother John 
for $2,000,000 and go off to do your Master’s Degree in the UK. Though you will be occupying the 
establishment from your grandmother for free, you have decided that you need to make some 
improvements to the property which will cost you $1,500,000. Additionally, you will spend $275,000 
in bar stools, tables and decorations. If this space had been leased out, it would have fetched a 
lease rental of $75,000 per year. You will depreciate the assets over 7 years using MACRS. You have 
determined that you would need an average cash balance of $15,000 and inventory of $20,000 while 
Accounts payable should average $10,000. You plan to borrow the money from a local bank and pay 
interest at a rate of 15 percent. To increase your chances of success at the business you plan to 
have your cousin Johnathan to conduct a market survey which will cost you $100,000. Your new 
venture will decrease the revenue your family business will earn by $15,000 per year and you have 
agreed to allow your father to take this amount from your allowance as a shareholder of the family 
restaurant.

Revenues are projected to be $500,000 the first year and is expected to increase by 20% the second 
year, 15% the third year and to continue to increase at 10% thereafter. Fixed annual operating 
costs are expected to be salaries of $110,000, Utilities $75,000, Food and Liquor License is 15% of 
gross revenues and taxes are 40% of net
revenues.

 

Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
CONCEPTS IN FED.TAX., 2020-W/ACCESS
CONCEPTS IN FED.TAX., 2020-W/ACCESS
Accounting
ISBN:
9780357110362
Author:
Murphy
Publisher:
CENGAGE L
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning