Create a balance sheet and flow statement of this given data

Create a balance sheet and flow statement of this given data i have also attached drive link of this data

https://drive.google.com/file/d/1B6G9Xc8cdtyiKfG77RjTX77i4qvCl5h4/view?usp=drivesdk

b. Depreciation Description Cost Depreciation 2,000,000 800,000 200,000 500,000 90,500 160,000 20,000 50,000 900,000 180,000 Cottages Suzuki Generator Furniture and Fixtures Machinery and Equipments Moveable Restaurant Camping Equipments Total 700,000 100,000 200,000 20,000 5,300,000 620,500 c. Employees Yearly Salaries Employees annually salaries will be as under: Monthly Yearly Jobs/labor No. Salary Months Salary Aug-Dec 2021 Chef 1 30,000 5 150,000 Helper 1 20,000 5 Waiter 1 15,000 5 75,000 Driver 1 12,000 5 60,000 Cleaner 1 8,000 5 40,000 Total: 5 425,000 Yearly Months Salary Jan-Dec 2022 12 360,000 12 240,000 12 180,000 12 144,000 12 96,000 1,020,000 100,000 c. Employees Availability The required skilled employees are locally available at co-operatively reasonable rates No problem is foreseeable. Loan Amortization Schedule Installment amount : 113227.402 Terms in months : 60 Loan Amount : 6000000/- Effective Loan Amount : 6000000.0 Interest : 5.0 Discount amount : 0.0 Down payment amount : 0.0 Installment frequency : Monthly b. Depreciation Description Cost Depreciation Cottages Suzuki Generator 2,000,000 800,000 200,000 500,000 90,500 160,000 20,000 50,000 900,000 180,000 Furniture and Fixtures Machinery and Equipments Moveable Restaurant Camping Equipments Total 700,000 100,000 200,000 20,000 5,300,000 620,500 c. Employees Yearly Salaries Employees annually salaries will be as under: Monthly Yearly Jobs/labor No. Salary Months Salary Aug-Dec 2021 Chef 1 30,000 S 150,000 Helper 1 20,000 5 100,000 Waiter 1 15,000 5 75,000 Driver 1 12,000 5 60,000 Cleaner 18,000 5 40,000 Total: 5 425,000 Yearly Months Salary Jan-Dec 2022 12 360,000 12 240,000 12 180,000 12 144,000 12 96,000 1,020,000 c. Employees Availability The required skilled employees are locally available at co-operatively reasonable rates. No problem is foreseeable. Required Capital: The owner intends to fully establish and equip Resort by getting a loan of Rs 6,000,000/- from the Habib Metro Bank Ltd under Prime Minister's Kamyab Jawan Youth Entrepreneur Scheme. The owner is willing to provide security and mortgage his personal property/Assets of the business against the loan in favor of the said bank. The owner will also contribute Rs. 2,000,000/- from his own funds in cash. Description Amount 1. Business Loan 2. Entrepreneur Capital Total 6,000,000 2,000,000 8,000,000 Uses A) Project Cost 1. Cottages 2. Suzuki 3. Generator 6 KV 4. Restaurant 5. Furniture and Fixtures an 2,000,000 8,000,00 2,000,00 7,000,00 4,000,00 a. Beds b. Chairs C. Tables 9,000,00 d. Park benches e. Swings for kids 6. Machinery and Equipments Deep freezers (2) Fridge (1) Juicer (3) Geezers(6) Grass cutting machine (1) Owen (2) Stoves (3) 7. Park and Parking 8. Mosque 9. Camping Equipments a. Camping tents(8) b. Sleeping bags (10) 10.Shops ( Cabin shops) a. Tuck shop b. Antique shop c. Medical store 11. Food Items 12.Salaries 13.Boundary wall and plantation 6,000,00 2,000,00 2,000,00 3,000,00 3,800,00 1,020,000 3,000,00 b. Depreciation Description Cost Depreciation 2,000,000 800,000 200,000 500,000 90,500 160,000 20,000 50,000 900,000 180,000 Cottages Suzuki Generator Furniture and Fixtures Machinery and Equipments Moveable Restaurant Camping Equipments Total 700,000 100,000 200,000 20,000 5,300,000 620,500 c. Employees Yearly Salaries Employees annually salaries will be as under: Monthly Yearly Jobs/labor No. Salary Months Salary Aug-Dec 2021 Chef 1 30,000 5 150,000 Helper 1 20,000 5 Waiter 1 15,000 5 75,000 Driver 1 12,000 5 60,000 Cleaner 1 8,000 5 40,000 Total: 5 425,000 Yearly Months Salary Jan-Dec 2022 12 360,000 12 240,000 12 180,000 12 144,000 12 96,000 1,020,000 100,000 c. Employees Availability The required skilled employees are locally available at co-operatively reasonable rates No problem is foreseeable. Loan Amortization Schedule Installment amount : 113227.402 Terms in months : 60 Loan Amount : 6000000/- Effective Loan Amount : 6000000.0 Interest : 5.0 Discount amount : 0.0 Down payment amount : 0.0 Installment frequency : Monthly b. Depreciation Description Cost Depreciation Cottages Suzuki Generator 2,000,000 800,000 200,000 500,000 90,500 160,000 20,000 50,000 900,000 180,000 Furniture and Fixtures Machinery and Equipments Moveable Restaurant Camping Equipments Total 700,000 100,000 200,000 20,000 5,300,000 620,500 c. Employees Yearly Salaries Employees annually salaries will be as under: Monthly Yearly Jobs/labor No. Salary Months Salary Aug-Dec 2021 Chef 1 30,000 S 150,000 Helper 1 20,000 5 100,000 Waiter 1 15,000 5 75,000 Driver 1 12,000 5 60,000 Cleaner 18,000 5 40,000 Total: 5 425,000 Yearly Months Salary Jan-Dec 2022 12 360,000 12 240,000 12 180,000 12 144,000 12 96,000 1,020,000 c. Employees Availability The required skilled employees are locally available at co-operatively reasonable rates. No problem is foreseeable. Required Capital: The owner intends to fully establish and equip Resort by getting a loan of Rs 6,000,000/- from the Habib Metro Bank Ltd under Prime Minister's Kamyab Jawan Youth Entrepreneur Scheme. The owner is willing to provide security and mortgage his personal property/Assets of the business against the loan in favor of the said bank. The owner will also contribute Rs. 2,000,000/- from his own funds in cash. Description Amount 1. Business Loan 2. Entrepreneur Capital Total 6,000,000 2,000,000 8,000,000 Uses A) Project Cost 1. Cottages 2. Suzuki 3. Generator 6 KV 4. Restaurant 5. Furniture and Fixtures an 2,000,000 8,000,00 2,000,00 7,000,00 4,000,00 a. Beds b. Chairs C. Tables 9,000,00 d. Park benches e. Swings for kids 6. Machinery and Equipments Deep freezers (2) Fridge (1) Juicer (3) Geezers(6) Grass cutting machine (1) Owen (2) Stoves (3) 7. Park and Parking 8. Mosque 9. Camping Equipments a. Camping tents(8) b. Sleeping bags (10) 10.Shops ( Cabin shops) a. Tuck shop b. Antique shop c. Medical store 11. Food Items 12.Salaries 13.Boundary wall and plantation 6,000,00 2,000,00 2,000,00 3,000,00 3,800,00 1,020,000 3,000,00