I want to operate a HOT DOG cart. I wish to write a base case scenario...

I want to operate a HOT DOG cart. I wish to write a base case scenario so that bankers can make a loan.

Facts

I own land -- $ 70,000. I intend to keep it. Land will need clean-up at the end.

Clean up costs -- $ 2.500.

Equipment -- $ 25,000.

Installation costs -- $ 2,500.

Working Capital -- $ 2,000.

MACRS -- 5 year table

Life of project -- 6 years.

Variable costs -- 45%.

Fixed Costs -- $ 750.00 per month.

Tax rate -- 30%.

Sell 100 hot dogs a day @ $1/each

I want at least a 8% return on this project. Can you build an excel spread sheet for me to show that bankers that this is a viable business? Thank you.

Please help me compute:

Net Present Value (NPV).

Profitability Index (P.I.).

Internal Rate of return (IRR).

Modified Internal rate of Return (MIRR).

Payback.

Make sure your XL sheet is readable and the banker (ME) can see the results on the 1^st sheet.

Solutions

Expert Solution

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Case 1: Shake Shack When famed fine-dining restaurateur Danny Meyer opened a hot dog cart in...

Case 1: Shake Shack When famed fine-dining restaurateur Danny Meyer opened a hot dog cart in New York City’s Madison Square Park in 2001, the venture drew legions of customers curious to experience Meyer’s take on all-American street food. The curious became the committed and Meyer’s little experiment acquired a permanent structure in the park – the Shake Shack. The Shack regularly drew long lines, leading Meyer to build a company around the concept. In a few years, Shake Shack...

To get the Frank's hot dog cart off the ground, we need to come up with...

To get the Frank's hot dog cart off the ground, we need to come up with a list of assets he will need. In your initial post, name and describe a single item. Why does Frank need this item to run his hot dog stand business? (Note: Please name only one item. You will have the opportunity to suggest additional items in your response posts.) After completing your initial post, respond to at least two other classmates. In each response,...

Here is the fact pattern I want you to base your answer on: You want the...

Here is the fact pattern I want you to base your answer on: You want the latest in mini laptop computers. You find what you need by searching on the Internet. The seller is in Taiwan. You negotiate a deal with the seller over the Internet and buy the computer. The seller agrees to ship you the computer by boat. Answer this Question: (minimum 200 words; any format) What terms (words) would you insist be included in the Sales Contract...

Consider this scenario: I am the owner of a burger store and I want to expand...

Consider this scenario: I am the owner of a burger store and I want to expand my business. I need to prepare a human resource management plan to show an overview of my human resource management system. This plan is the bigger picture that shows the synergy between all my human resource management functions. I need to do to an overview on how important my employees (chef, waiters, restaurant manager) are in making or breaking my business expansion. Please provide...

QUESTION 8 In a base-case scenario, the output is determined by assuming a. worst values that...

QUESTION 8 In a base-case scenario, the output is determined by assuming a. worst values that can be expected for the random variables of a model. b. the most likely values for the random variables of a model. c. the mean trial values for the random variables of a model. d. best values that can be expected for the random variables of a model. e. None of the above 1.5 points QUESTION 9 The points where constraints intersect on...

I want to find out which SPSS test I would use in this scenario: In this...

I want to find out which SPSS test I would use in this scenario: In this scenario a social psychologist working for an advertising firm was interested in whether the frequency of exposure to an advertisement would have an effect on the liking of that ad. He suggested that the more often a subject was exposed to an ad would have an effect on how much she / he would enjoy the ad. The study involved exposing a subject to...

Consider this scenario: I am the owner of a burger store. I want to expand my...

Consider this scenario: I am the owner of a burger store. I want to expand my business. I have to recruit a waiter and an assistant manager. My question is: What is the objective of my training plan? Explain the role of training in my business expansion? Please provide justifications for your answer. Note: If you are not sure how to fulfill the requirements needed, please do not attempt the question. Your help is very much appreciated. Thank you.

For university, I have to write a Research paper and i want to examine whether there...

For university, I have to write a Research paper and i want to examine whether there is a relationship (correlation)between hours worked in a Country per week and the Happiness Index points as the dependent variable. However, it has to be a mutiple linear regression model but I struggle with finding more independent variables. Can somebody help me here?

I want a case study with question and answer of this topic : time value of...

I want a case study with question and answer of this topic : time value of money that include present value and future value also annuity and compound.

SCENARIO 4: I want to know the percentage of people who think gold is the best...

SCENARIO 4: I want to know the percentage of people who think gold is the best color among all iPhone options. Anyone with a smartphone can answer. I want my margin of error to be +/- 3 percentage points. I want to use a z-value of 1.96. 1. Sample Size Formula to Use: [ answer here ] 2. Confidence Interval set to [ answer here ] because [explain why it is the right choice for this scenario] . 3. Margin...

Subjects