Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The start-up capital is $100,000. Prepare a cash flow budget to assess the need for additional cash. Action : Create a budget that projects cash
The start-up capital is $100,000.
- Prepare a cash flow budget to assess the need for additional cash.
Action: Create a budget that projects cash inflows and outflows to determine if the initial capital is sufficient or if additional funding is required.
2. Calculate the payback period and Net Present Value (NPV) of the project.
Action: Assess how long it will take for the project to repay its initial investment (payback period) and calculate the NPV to evaluate the project's profitability over time.
1. Gavin and Sarah's Plant-based Organic Barbeque Grilled Burgers Sales Budget For the First Three Years \begin{tabular}{|c|c|c|c|c|} \hline & ,..Year.1.... & Y..Year? & Year 3 & ....Total \\ \hline Units & 14800 & 24369 & 29234 & \\ \hline Seling price & $14.90 & \$17.14: & $19.71: & \\ \hline Sales & 3217,540 & $417,546 & 3576,063 & $1,211,149 \\ \hline & & & & \\ \hline & & & & \\ \hline \end{tabular} 2.1. Gavin and Sarah's Plant-based Organic Barteque Grilled Burgers Variable and Fixed Expenses For the First Three Years \begin{tabular}{|c|c|c|c|c|} \hline Variable Expenses & Year 1. & Year 2 & Year 3 & Total \\ \hline Cast of gaods sald/stocks & 87.016: & 167018: & 230,425 & 484.460 \\ \hline Beverages & 8.702 & 9137 & 9594 & 27432 \\ \hline Accounting fees & 3263 & 3.589 & 3948 & 5.350 \\ \hline Bark fees and charges & 180 & 240 & 300 & 720 \\ \hline Kitchen utensils/bols ( $300 ) & 5.439 & 5982 & 6.5814 & 18.001! \\ \hline Mator vehicle expenses & 4.351 & & 5264 & 14401 \\ \hline Other expenses & 2175 & 2393 & 2632 & 7.201 \\ \hline Repairs and maintenance & 4.351 & 4.786 & 5264 & 14401 \\ \hline Shipping and delivery costs & 6.526 & & 7.897 & 21602 \\ \hline Wages and Salaries & 43,500 & 47,859 & 52.645 & 144,011 \\ \hline Total variable expenses & $165,510 & $252,969 & $324,550 & \$ 743,030 \\ \hline \multicolumn{5}{|l|}{2.2 . } \\ \hline \multicolumn{5}{|l|}{ Fixed Expenses: } \\ \hline Actvertising and marketing & 2175 & 2393 & 2632 & 7201 \\ \hline Insurance & 5.439 & 5962 & 6.581 & 18.001! \\ \hline Kitchen equipment ( $300) & 21,754 & 23929 & 26.322 & 72006 \\ \hline Rent & 15228 & 16.751 & 18.426 & 50.404 \\ \hline Uslities (electrioity, gass, water and belephone) & 10.877 & 11,965 & 13.161! & 36,003 \\ \hline Total fixed expenses & 55,473 & \$s 61,020 & \$\$ 67,122 & $ \\ \hline Total Various and Fixed Expenses & $220,983 & $313,989 & $391,672 & $926,644 \\ \hline Net ProfitLcoss & (3,443) & \$ 103,557 & $184,391 & $284,506 \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started