In Progress

Glen Rose Spreadsheet update and improvement

We need to update the model of Glen Rose using Gold Creek as the example. This is a single family home Greenfield project which will be built in the American Midwest.

1 The tabs on Glen Rose and spread sheets for Cash flow 1&2 and 3& 4 are out of order. Please make 1&2 before 3& 4

2 The Data for Glen Rose are in tabs Working Copy, Profit and Loss Statement, Cash flow 1&2 and Cashflow 3&4.

3. Phase I Cashflow and Cashflow all Phases contain old data and Old categories; Please update per the data and style in Gold Creek Spreadsheet

4. Please carefully go through Working Copy, Profit and Loss Statement, Cash flow 1&2 and Cashflow 3&4. So that they will are complete. For example in Cashflow 1&2 there is no entries after December, they should be filled in.

5. Check the formulas and make sure they are in the cells;

6. Check that all the dates and months are consistent

7. We need a loan module which will calculate interest and principal based upon an interest rate which will be put in. The interest needs to be inputed into all sheets in the place provided.

8. In the cash flow all phases tab you need to create a loan draw and a repayment based upon cash flow; assume that 50% of profits would be added to the loan sinking fund and please make a variable where we can varry the amount of profit devoted to the sinking fund from 0-100%;

9 Please look for any inconsistencies.

10 Convert to xlsx

Skills: Accounting, Excel, Finance

See more: glen rose tabs, spreadsheet accounting, principal accounting, check cash, cash flow accounting, accounting gold, accounting needs, xlsx, update old, update look, make entries accounting, spreadsheet excel accounting, spreadsheet 2, repayment, formulas sheets, create spreadsheet, accounting spreadsheet, module tab, spreadsheet loan repayment, need spreadsheet built, check spreadsheet, spreadsheet project, gold loan project, update dates, accounting cash

About the Employer:
( 6 reviews ) West Orange,, United States

Project ID: #1139648

Awarded to:

waqar21081974

Please see your PMB

$100 USD in 4 days
(35 Reviews)
5.3

5 freelancers are bidding on average $98 for this job

vbexcel

Excel expert with a financial background.

$90 USD in 1 day
(28 Reviews)
5.5
bluefox4ever

Dear Hiring Manager, I want to do this "Glen Rose Spreadsheet update and improvement" project now, let's start immediately. I have read the job description. Please send me the excel file and read my PM Regards, More

$100 USD in 3 days
(9 Reviews)
3.5
Uthe2009

I’m available to work on your project. Kindly check on your PMB. Thank you.

$50 USD in 2 days
(6 Reviews)
3.0
Brijrat

I ma hard working person....... plz give the opportunity......... and check my PMB

$150 USD in 30 days
(0 Reviews)
0.0