Prepare Budget of Five Year of Any selected Company Assumptions 1 Sales Unit 10% increase in every year Price 5% increase in every year 2 Material Cost QTY increase as percentage of sales price 4% increase in every year 3 Labor cost Variable Increase as % of sales and annual increment is 5% Fixed 5% increase in every year 4 Overheads Variable Increase as % of sales plusannual inflation is 3% Fixed 3% increase in every year 5 Depreciation Fixed asset increase by 10% every year and depreciation will be applicable weighted average rate of current year 6 Selling and Distribution Expenses Variable Increase as % of sales plus inflation 3% Fixed 3% increase in every year 7 Admin Expenses 3% increase in every year 8 Finance Cost in case of loan or over draft 9% markup will be paid 9 Finance Income on surplus amount bank will pay 7% interest- Surplus mean 10% above of any cash and bank balance 10 Other non Operating income and expenses Will increase as percentage of Tax WPPF 5% of profit before tax WWF 2% of profit before tax 11 Income Tax 29% Income tax rate is applicable Assets and liabilities

Account receivable trade one month of sales

Account payable trade One Month of purchase

Inventory Finished Good 15 days of sales

Work in process Percentage of production

Raw Material 10 days of consumption

Fixed Assets 10% increase every year

Long term liabilities paid as per current structure

Other Assets and liabilities Increase as % of sales

Required 5 Year Forecast Income Statement

5 Year Forecast Balance Sheet

5 Year Forecast Cash Flow

Ratio Analysis

Please try to the answer in excel sheet and please if possible choose Pakistan company.