I am preparing financial pro-formas for a non-profit business for building homes for the poor and homeless worldwide. I want to develop the data for one country for 5 years, and replicate that for 55 countries throughout the world. Each country will have the same initial data. I will want to track, on a quarterly basis,
(1) Total cost of construction
(2) Total homes built
(3) Total labor force
(4) Unit cost of construction.
(1) Four laborers can build one house in one month.
(2) Initial unit cost to be $20,000.
(3) First 5 months activities will be startup.
(4) Home construction will begin in month 6 with one home built.
(5) Home construction will grow from one unit in month 6 to 250 units in month
(6) Labor in month 6 will begin with 4 men and grow to 1000 in month 24.
(7) Growth rate for months 25 through 60 to be 10%/month for homes; labor and costs
(8) Admin costs to be $1,012,000.00 at end of first year and grow at 12%/year for years 2, 3, 4, and 4.
This data to be replicated for some 55+/-countries after country #1. Number 2 starts in month 7; country 3 in month 8, and so on for the 60 month period. Quarterly reporting periods on above data, and total costs at end of 60 month period.
39 freelance ont fait une offre moyenne de 192 $ pour ce travail
Hi, I am good at Excel and formulas. I have gone through the description. However, i would like to discuss few points. Looking forward to discuss in the chat.
HI. I WOULD BE HAPPY TO ASSIST YOU ON YOUR PROJECT. I HAVE MUCH DATABASE DEVELOPMENT AND DATA REPORTING EXPERIENCE,USING MS ACCESS AND MS EXCEL. PLEASE FEEL FREE TO LEAVE FURTHER DETAIL. REGARDS
Hello. It looks like a financial projection and feasibility study for a non-profit housing project. I am a Chartered Accountant and I can do this task with 100% accuracy and quick turnaround time. Thanks