Description
Assistance in writing a financial analysis and funding plan, attached is the concept of the fictional business..
which includes your analysis of the projected costs, revenue streams, and net present
value for the concept from launch until two years after the breakeven point. Be sure to include a budget, an assessment of assets and liabilities, your anticipated
sources of funding, and the associated costs of attaining that capital as part of your analysis. Support your analysis with relevant primary and secondary data in
an appendix, specifying any relevant assumptions and limitations. You should include, among other support, sales forecasts, cash flow statements, income
projections, and any other relevant calculations or financial reports.
Critical Elements:
- Analyze the projected costs, revenue streams, and net present value for the concept from launch until two years after the breakeven point.
- Include the following as part of your analysis:
o Budget
o Assessment of assets and liabilities
o Anticipated sources of funding
o Associated costs of attaining that capital
Include relevant proforma financial reports: o Sales forecasts
o Cash flow statements
o Income projections
o All other relevant reports specific to your concept or idea
Guidelines for Submission: Your draft must contain all of the elements listed above. It should be 5 to 8 pages in length (excluding the title page, references, and appendices) using 12-point Times New Roman font, with one-inch margins. You may include summary pictures, charts, graphs, or other explanatory diagrams as needed to successfully explain the concept and implementation, but should use appendices for detailed supporting documentation. Your paper should follow APA guidelines. You must include at least 5 scholarly sources. Cite your sources within the text of your paper and on the reference page.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Kindly confirm the paper. I understand it required much calculations, analysis and planning. Go through it and let me know if you need something to be rectified!
Running head: SENIOR CONCIEGERE BUSINESS
1
Financial Analysis and Financial Plan
Name
Instructor
Course
Date
SENIOR CONCIEGERE BUSINESS
2
Pre-Operational Cost
Description
Renovation
Licensing and permit
Electricity
Telephone
Banking services
Advertising
Machinery and equipment
Furniture and fittings
Purchases
Miscellaneous
Rent
TOTAL
Cost
10000
4350
3000
1500
1000
8000
150000
10000
30000
10000
4000
231850
Working Capital
Current assets
Debtors
stock
prepayments
Cash at hand
Cash at bank
Total current assets
Current liabilities
Creditors
Short term loan
accruals
Total current liabilities
Working capital
Year 2014
Year 2015
Year 2016
10000
20000
30000
60000
200000
20000
30000
40000
70000
220000
30000
40000
50000
80000
240000
320000
20000
100000
50000
170000
150000
380000
40000
50000
30000
440000
60000
70000
20000
120000
260000
150000
290000
SENIOR CONCIEGERE BUSINESS
Sales
Sales return
Net sales
Opening stock
Add: Purchases
Less: Closing stock
Cost of goods sold
Gross profits
Less: Expenses
Salary
Rent
Electricity
Bank charges
Telephone expenses
Permit and license
Total expenses
Net profit before tax
Less: tax (3%)
Net income after tax
3
Profit and Loss Account For The
Last Three Years
Year 2014
Year 2015
990000
1200000
10000
20000
980000
1180000
20000
30000
100000
200000
(30000)
(50000)
90000
180000
890000
1000000
Year 2016
1210000
40000
1170000
50000
250000
(70000)
230000
940000
200000
48000
36000
2000
18000
5000
300000
60000
50000
5000
30000
5000
220000
50000
40000
3000
20000
5000
307000
583000
17490
565510
338000
662000
19860
642140
450000
490000
14700
475300
SENIOR CONCIEGERE BUSINESS
4
Balance Sheet for The Last three Years
Year 2014
Year 2015
Fixed assets
Equi...