10- An Investor has decided to build an IV solution factory. The assumptions for this project are as follow: Acquire 10.
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
10- An Investor has decided to build an IV solution factory. The assumptions for this project are as follow: Acquire 10.
Thank you in advance
10- An Investor has decided to build an IV solution factory. The assumptions for this project are as follow: Acquire 10.000 m² of land for $30/m² The registration of the land costs 6% of the land price Build 2000 m² for $800/m² Build a warehouse of 2000 m² for $300/m² Build offices for 250 m² at the cost of $500/m² Engineering fees are for 12% of the total built area Furniture is estimated to be 20 units for $2000 each, Equipment for production line estimated at $4.000.000 4 vehicles are needed for $30.000 each IT system for $30.000 A generator for $80.000 is needed Human resources needed are as follows: Number Monthly Salary 3,000 1,000 Managers Stock Keeper Purchasing Pharmacist 1,000 1,500 800 Technicians (sterilzation + production) Warehouseman 500 Drivers 4 500 The social insurance for employees is 21.5% Yearly production of 6.000.000 units. The selling price is $1 per unit Yearly inflation rate is 10%, affecting only expenses Depreciation rates are: 2.5% for building, 20% for furniture, vehicles, generator & IT, and 15% for the equipment line Using Excel, Make the Income Statement for the 7 coming years. Make the related graph. 4 1 1 1 6 3