Financial Analysis for Hot dog truck

Content Type

User Generated

User

onynonynon

Subject

Business Finance

Description

Frank opens a hot dog truck near two universities, I already finished the first part which is the income statement and assets in balance sheet. Pls fill out the liabilities and equities and write a 2-4 pages analysis.

Fast forward a few months...Your friend asks you how your business is doing and you are unsure how exactly to answer. In fact, you are not necessarily sure how your business is going since you are so new to this! This part will help you organize your thoughts and come up with a more formalized process and financial reporting can help you demonstrate your success (or lack thereof!).

For your cart, come up with a way to determine profit and financial position. Expand your Excel spreadsheet from part 1 by adding an additional tab. There is no specific format for this. Data should be reasonable based on your projections from Part 1 and include all expenses. Your grade is not dependent on whether you are making a profit.

Use the momentum from the discussion forums from week's 6-7 where we collectively brainstormed methods of (a) if the business was profitable and (b) how to measure profitability in a professional format.

Include an analysis that summarizes your findings in a professional manner.

This part of the project should be approximately 2 - 4 pages including the financials.

Thanks!

Unformatted Attachment Preview

Frank's Hot Cog Cart Financials Bank Write-Up: P is a city that has so many college students, so that means it is also a good place to open up a hot dog food truck. I pick my location near T street, because there are a lot of students who go to B and R universities will pass there during classes and grab foods. They do not have much time during two classes, so hot dog is their good choice during two classes. I know there is a Chinese food truck near B university, but no hot dog truck there yet. So it might be good opportunity at the T streent, and also the price may attract students. I choose four dollars each for the hot dog, and students would like to grab some cheap and easy to eat food during short breaks. I would Current Financial Statements (use the links below to access the templates) Income Statement Balance Sheet Frank's INCOME STATEMENTS Three Months Ended December 31, Six Months Ended December 31, 2018 Revenue 2018 $ 14.400 $ 28.800 Cost of revenue $ 5.796,00 $ 11.592,00 General and administrative $ 3.667,25 $ 7.334,50 Total operating expenses $ 1.800,00 $ 3.600,00 $ 3.136,75 $ 6.273,50 Operating expenses: Net income Back to Main Frank's BALANCE SHEETS December 31st, 2018 Assets (expand the list to include all assets) Cart $ 14.290,00 Hot Dogs $ 16.200,65 Buns $ 5.382,00 Mustard $ 275,33 Ketchup $ 190,47 Napkins $ 417,31 food tray $ 289,87 forks $ 223,06 $ 223,49 spoons refrigerator $ 379,00 Total $ 37.871,18 Liabilities and stockholders' equity (Not needed for Part 1) Current liabilities: Accounts payable Accrued expenses Other Total current liabilities Long-term debt Total liabilities Commitments and contingencies Stockholders' equity: Money from Mom & Dad Total stockholders' equity Total liabilities and stockholders' equity Back to Main Frank's Hot Cog Cart Financials Bank Write-Up: P is a city that has so many college students, so that means it is also a good place to open up a hot dog food truck. I pick my location near T street, because there are a lot of students who go to B and R universities will pass there during classes and grab foods. They do not have much time during two classes, so hot dog is their good choice during two classes. I know there is a Chinese food truck near B university, but no hot dog truck there yet. So it might be good opportunity at the T streent, and also the price may attract students. I choose four dollars each for the hot dog, and students would like to grab some cheap and easy to eat food during short breaks. I would Current Financial Statements (use the links below to access the templates) Income Statement Balance Sheet Frank's INCOME STATEMENTS Three Months Ended December 31, Six Months Ended December 31, 2018 Revenue 2018 $ 14.400 $ 28.800 Cost of revenue $ 5.796,00 $ 11.592,00 General and administrative $ 3.667,25 $ 7.334,50 Total operating expenses $ 1.800,00 $ 3.600,00 $ 3.136,75 $ 6.273,50 Operating expenses: Net income Back to Main Frank's BALANCE SHEETS December 31st, 2018 Assets (expand the list to include all assets) Cart $ 14.290,00 Hot Dogs $ 16.200,65 Buns $ 5.382,00 Mustard $ 275,33 Ketchup $ 190,47 Napkins $ 417,31 food tray $ 289,87 forks $ 223,06 $ 223,49 spoons refrigerator $ 379,00 Total $ 37.871,18 Liabilities and stockholders' equity (Not needed for Part 1) Current liabilities: Accounts payable Accrued expenses Other Total current liabilities Long-term debt Total liabilities Commitments and contingencies Stockholders' equity: Money from Mom & Dad Total stockholders' equity Total liabilities and stockholders' equity Back to Main
Purchase answer to see full attachment

Tags: accounting Financial Statements Income Statement Balance Sheet Hot Dog Truck Financial Analysis