For this assignment I need to create a fake income sheet etc with whatever numbers. The company i created is VR (virtual reality) cycling. i need to answer 10. d, e, and f. the purpose is to set an example of what those numbers would look like for my VR company.
10. d
10. e
10. f
i hope this is better
10:32 What are you earnings before interest and taxes (EBITY? What is your cumulative profit and loss (P&L? 10.e. Complete the pro forma cash flow for the first year. This should have a column of numbers for each month in the first year, plus a column (or more) for the month before you start business. > How much do you expect to sell every month? How much money will this bring in? This is your cash inflow. How much up-front cash do you need to start the business? Deposit for lease, down payment on equipment, permits, improvements, supplies, insurance, computer advertising, etc How much will is cost to produce your productor service? COGS, labor What are your fixed costs? Salaries, rent, lease payments, advertising, insurance, utilities Calculate the net amount of money flowing in or out) cach month. What is the running cash balance! What is the cumulative cash balance? 10. How much cash will you need to start your business? Where will you get it (savings, a loan, venture capital, an angel...? 10.g. When will you break even? 10.h. Do these numbers look attractive enough to proceed? How can they be improved? 10.1. What other information do you need for your financial projections? Previous Next 28 Dashboard Calendar To Do Notifications bos 10.b. How much do you expect to sell? How will sales change over time? 10.c. How much will it cost to produce your product or service? 10.d. Complete a pro forma income statement for five years. You do not need to break this down by month. Your income statement may have five columns of numbers: one for each of the first five years. What are the expected revenues? > What are the variable costs? Cost of goods sold (COGS), labor. What are your fixed costs? Salaries, depreciation, administrative expenses, rent, equipment lease, advertising, insurance, utilities, etc. What are you earnings before interest and taxes (EBIT)? What is your cumulative profit and loss (P&L)? 10.e. Complete the pro forma cash flow for the first year. This should have a column of numbers for each month in the first year, plus a column (or more) for the month before you start business. > How much do you expect to sell every month? How much money will this bring in? This is your cash inflow. How much up-front cash do you need to start the business? Deposit for lease, down payment on equipment, permits, improvements, supplies, insurance, computer, advertising, etc. > How much will is cost to produce your product or service? COGS, labor. What are your fixed costs? Salaries, rent, lease payments, advertising, insurance, utilities. Calculate the net amount of money flowing in (or out) each month. What is the running cash balance? What is the cumulative cash balance? 10.f. How much cash will you need to start your business? Where will you get it (savings, a loan, venture capital, an angel...)? 10.g. When will you break even? 10.h. Do these numbers look attractive enough to proceed? How can they be improved
