Dear user bizwriter100,
I have lectured candidates of Chartered Financial Program in equity valuation, debt valuation, financial statement analysis, and corporate finance for over 5 years. Before that, I analyzed companies in manufacturing, property, telecom, and energy sectors in Asian countries.
To solve your problem, I can create separate linked worksheets for the balance sheet, profit and loss, cash flow. I will then discount the cash flows over several scenarios to arrive at a set of net present valuation.
To show you I understand your problem, here are questions that will help me do a better job (ie, the better they are answered, the better projection and valuation you will get):
How detailed are the "full set of financial statements" you have? Are they consistently formatted? Are they on yearly or quarterly basis? Is it a set that includes only historical years, or also projected years? Is there any breakdown of operations by business lines, or other relevant divisions? Do you have information on how each division grows? Do you have info on the risk of operations or costs? What are the discount rates you require?
I am an experienced financial analyst, but a new freelancer. This is why I bid low, hoping to build a reputation and later charge a higher rate. :)
Best regards and thank you for the opportunity,
Jason