Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Financial plan & Forecast Develop the Financial Plan for minimum 2 YEARS, Plan needs to include: 1. Cash flow projections by month; and by year;

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Financial plan & Forecast Develop the Financial Plan for minimum 2 YEARS, Plan needs to include: 1. Cash flow projections by month; and by year; 2 YEARS 2. Balance Sheet, by year; 2 YEARS 3. Business Financial Ratios, by year (breakeven, calculate ratios; like liquidity, profitability, efficiency and solvency); 4. Income Statement, by year; 5. Include a capital expenditures plan if your business has significant capital expenditures in its near-term horizon 6. In your financial plan you must include your assumptions. Project Cost Summary Year 1 Year 2 16 Months)|10 Months) I Total -ta 1FIXED ASSETS Furniture 10,000 160,000 85,000 60,000 10,000 160,000 85,000 50,000 Equipments and Machinery Decoration and Interior Setup Vehicles 2 RENT 195,000 195,000 3 WORKING CAPITAL Total Direct Cost of Sales 45,297 67,946 3,500 38,400 45,297 57,946 3,500 38,400 Water, Electricity &oil Direct salaries and wages Employee Allowances Indirect salaries and wa Employee Allowance Marketing and Advertising License Fee Vehicles Expenses Office Supplies 24,000 1,200 40,000 10,000 3,000 1,000 3,000 24,000 1,200 40,000 10,000 3,000 1,000 3,000 Gas/ Petrol Audit fees Maintenance 20,000 20,000 Employee Visa AEDAk (Include Labour Guarantee AED3k) 56,000 56,000 4 LOAN ADMIN FEES 5 INSURANCE 6 Full Loan Term 37,651 15,792 TOTAL PROJECT COST 878,707 Check Kindly use the following information for the financial plan Kindly provide it in excel sheet format Company producing and selling specialty Arabic Sweets Introducing range of low suger sweets. Concentrating on events and vip customers Financial plan & Forecast Develop the Financial Plan for minimum 2 YEARS, Plan needs to include: 1. Cash flow projections by month; and by year; 2 YEARS 2. Balance Sheet, by year; 2 YEARS 3. Business Financial Ratios, by year (breakeven, calculate ratios; like liquidity, profitability, efficiency and solvency); 4. Income Statement, by year; 5. Include a capital expenditures plan if your business has significant capital expenditures in its near-term horizon 6. In your financial plan you must include your assumptions. Project Cost Summary Year 1 Year 2 16 Months)|10 Months) I Total -ta 1FIXED ASSETS Furniture 10,000 160,000 85,000 60,000 10,000 160,000 85,000 50,000 Equipments and Machinery Decoration and Interior Setup Vehicles 2 RENT 195,000 195,000 3 WORKING CAPITAL Total Direct Cost of Sales 45,297 67,946 3,500 38,400 45,297 57,946 3,500 38,400 Water, Electricity &oil Direct salaries and wages Employee Allowances Indirect salaries and wa Employee Allowance Marketing and Advertising License Fee Vehicles Expenses Office Supplies 24,000 1,200 40,000 10,000 3,000 1,000 3,000 24,000 1,200 40,000 10,000 3,000 1,000 3,000 Gas/ Petrol Audit fees Maintenance 20,000 20,000 Employee Visa AEDAk (Include Labour Guarantee AED3k) 56,000 56,000 4 LOAN ADMIN FEES 5 INSURANCE 6 Full Loan Term 37,651 15,792 TOTAL PROJECT COST 878,707 Check Kindly use the following information for the financial plan Kindly provide it in excel sheet format Company producing and selling specialty Arabic Sweets Introducing range of low suger sweets. Concentrating on events and vip customers

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Trap Doors And Trojan Horses An Auditing Action Adventure

Authors: D. Larry Crumbley, David Kerr, Veronica Paz, Lawrence Smith

1st Edition

1531021573, 978-1531021573

More Books

Students also viewed these Accounting questions