Question

In: Accounting

Business Plan - Food Delivery Business: Create three years of each: Cash flow, pro forma P&L,...

Business Plan - Food Delivery Business:

Create three years of each: Cash flow, pro forma P&L, and Balance sheet with the first year of each broken down monthly. You can choose any data points (You can assume all the #). Data points need to show an overall success in the startup company. First year = breakeven, following 2 years is in increase.

Solutions

Expert Solution

Note -

1.5% interest on loan payable semi annually ; principal repayment starts nest year

2.Assets depreciated over 10 year life

3.Business is done only on cash basis

Year 2 and Year 3 (Note - No tax has been assumed)


Related Solutions

Pro forma retained earnings - ex. #2 The bottom line on the pro forma P&L for...
Pro forma retained earnings - ex. #2 The bottom line on the pro forma P&L for the fiscal year that has just begun is $500,000. The top line is $3.5 million. The current balance in retained earnings is $2,100,000. A dividend payout ratio of 40% is anticipated. a) [review] What is the net profit margin? b) [review] Explain the answer to a) above. c) Forecast retained earnings at the end of the fiscal year that has just begun. d) Which...
1a. You have been asked to develop a pro forma statement of cash flow for an...
1a. You have been asked to develop a pro forma statement of cash flow for an office plaza. The information given to you is listed below: Property Information:                Age                                                                                        8 years                Rentable Space                                                                 300,000 sq.ft.                 # Stories                                                                              15                 # Tenants                                                                            40     Financial Information:                 Base Rent Avg.                                                                  $20 per sq.ft.                 Other Income/Parking                                                   $1.50 per sq.ft.                 Expenses Recoverable from Tenants                       $2.50 per sq.ft.                 Current Vacancy                                                               equals to 5% of...
Develop a pro forma set of income and cash flow statements for a wind energy plant...
Develop a pro forma set of income and cash flow statements for a wind energy plant with the following parameters, and calculate the plant’s NPV, IRR and LCOE: -Overnight capital costs are $1.2 million, all incurred in Year 0. There is no land acquisition cost assumed here. -The plant has a salvage value of $200,000 at the end of the plant’s life -Annual revenues from spot market sales are $400,000. -Annual operating costs are $30,000. -The plant qualifies for the...
Prepare a pro-forma statement by using assumptions to calculate the annual operating net cash flow for...
Prepare a pro-forma statement by using assumptions to calculate the annual operating net cash flow for three years to calculate the the NPV and IRR. Assess project feasibility using NPV and IRR method. Company is Z-energy For the data part you can refer to the Yahoo finance or assume any relevant data according to the company
Prepare a pro-forma statement by using assumptions to calculate the annual operating net cash flow for...
Prepare a pro-forma statement by using assumptions to calculate the annual operating net cash flow for three years to calculate the the NPV and IRR. Assess project feasibility using NPV and IRR method. Company is Z-energy For the data part you can refer to the Yahoo finance or assume any relevant data according to the company
Capital Budgeting Risk Analysis Project Instruction Create the pro forma income statement and estimate the cash...
Capital Budgeting Risk Analysis Project Instruction Create the pro forma income statement and estimate the cash flows for the following project. Decide whether to accept this project based on analysis of the NPV, Profitability Index, and IRR. Project Assumptions (Base Case) Equipment Life 6 Years Initial Equipment Cost $2,500,000 in year 0 Depreciation Straight Line Method Initial Revenue $1,000,000 in year 1 Revenue growth rate year 2 10% Revenue growth rate year 3 15% Revenue growth rate year 4 10%...
I need to create a cash flow statement for 4 quarters. It is a new business...
I need to create a cash flow statement for 4 quarters. It is a new business and my professor provided me with very little information. I basically have to create a cash flow statement from scratch with made up information.
A project will produce an operating cash flow of $91,500 a year for three years. The...
A project will produce an operating cash flow of $91,500 a year for three years. The initial cash outlay for equipment will be $188,000. The net aftertax salvage value of $17,000 will be received at the end of the project. The project requires $52,000 of net working capital up front that will be fully recovered. What is the net present value of the project if the required rate of return is 14 percent? A. $22,318.76 B. $19,002.37 C. $15,450.93 D....
-Company A's free cash flow is estimated to be $75 million for the next three years....
-Company A's free cash flow is estimated to be $75 million for the next three years. -expect growth of 5 percent per year in free cash flow -Company A has 18 million shares outstanding, cash on hand of $50 million, liabilities of $155 million, and a weighted average cost of capital of 8 percent. If you want to become an owner (a shareholder), how much can you expect to pay per share? (Do not round intermediate calculations. Round your final...
A project costs $1000 today and will generate a cash flow of $3173 three years from...
A project costs $1000 today and will generate a cash flow of $3173 three years from now. If the interest rate is 3%, what is the net present value of the project?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT