security valuation in excel

I need a finance/security valuation expert on this task. Will provide more information once I have chosen tutor. Task is urgent.

c) Choice of valuation methodology: In this section you outline your research

and valuation methodology, choice of tools, models and metrics that you

used in your research of the security.

d) Financial forecasts: The report should include 5 years of actual data of

earnings, equity, debt, etc., 4 years of annual projections (Income

Statements, Balance Sheets and Cash Flow Statements) and terminal value

calculations. (40 points)

e) Target price: Using your chosen valuation formula you will have come up

with a target price for your security. Highlight this price.
f) Ratios: Financial ratios that are relevant to the industry to which your

company belongs. These typically include: operating margin, return on

capital employed) ROCE, return on assets (ROA), return on equity (ROE),

Tobin’s Q, earnings yield, debt-to-capitalization, times interest earned,

market-to-book, EPS, P/E, inventory turnover, receivables turnover, asset

turnover, etc.

g) Recommendation: Depending on the current price of the security and your

target price, make a “buy”, “hold”, or “sell” recommendation for the security.

Include the key reasons behind your recommendation. (10 points)

"Is this question part of your assignment? We can help"

ORDER NOW