would like to see all the work so that I can give points for the correct approach (assuming wrong answer). Therefore, copy paste your work from excel to doc and upload the excel sheet

VERY IMPORTANT: SOLVE ALL THE PROBLEMS USING EXCEL FORMULAS. If you feel that you have gone through all the material posted so far, especially the excel examples, but are still not clear on how to use the excel formulas, I recommend googling the ones you don't understand. There are several examples online.

Please use type = 0 in excel equations. E.g. when calculating payment using PMT = (rate, nper, pv, fv, type). Put 0 for type.

Your first job pays your $45,000 first year, $48,000 second year, $49,000 third year and $50,000 fourth year. Then you switch to another job and make $54,000 in the first year. Your pay increases by 5% for the next six years (11 years total). (15 PTS)

What is your salary in the 11^th year? (5PTS)

The Government tells you that the inflation is on average 2.5%. What is the Present Value (PV) of the salary you make in the 11^th year? (5 PTS)

What is the PV if the inflation is 6% - (5PTS)

Financial Statements

ABC CORPORATION

Balance Sheet

Year Ended December 31 (in $ millions)

Assets	2006	2005		Liabilities & Stockowners Equity	2006	2005
Current Assets				Current Liabilities
Cash	22.2	19.5		Accounts Payable	39.2	24.5
Accounts Receivables	18.5	13.2		Notes Payable / Short-Term Debt	4.5	3.2
Inventories	27.2	14.3		Current Maturities of Long-Term Debt	13.3	12.3
Other Current Assets	2.0	1.0		Other Current Liabilities	8.0	4.0
Total Current Assets	69.9	48.0		Total Current Liabilities	65.0	45.0
Long Term Assets				Long-Term Liabilities
Land	22.2	20.7		Long-Term Debt	98.9	56.3
Buildings	46.5	30.5		Capital Lease Obligations	---	---
Equipment	39.7	33.2		Total Debt	98.9	56.3
Less Accumulated Depreciation	(18.7)	(17.5)		Deferred Taxes	15.6	7.4
Net Property, Plant, and Equipment	89.7	66.9		Other Long-Term Liabilities	----	----
Goodwill	22.0	---		Total Long Term Liabilities	114.5	63.7
Other Long-Term Assets	41.0	14.0		Total Liabilities	179.5	108.7
Total Long Term Assets	152.7	80.9		Stockholders Equity	43.1	20.2
Total Assets	222.6	128.9		Total Liabilities and Stockholders Equity	222.6	128.9

ABC Corporation

Income Statement

Year Ended December 31 ($ in millions)

	2006	2005
Total Sales	198.8	176.1
Cost of Sales	(153.4)	(147.3)
Gross Profit	35.4	28.8
Selling, General and Administration Expenses	(13.5)	(13.0)
Research and Development	(9.2)	(7.6)
Depreciation and Amortization	(6.2)	(1.1)
Operating Income	16.5	7.1
Other Income	----	----
Earnings Before Interest and Tax (EBIT)	16.5	7.1
Interest Income (or Expense)	(7.7)	(4.6)
Pretax Income	8.8	2.5
Taxes	(0.7)	(0.6)
Net Income	8.1	1.9
Earnings per share	$0.556	$0.528
Diluted Earnings Per Share	$0.526	$0.500

ABC Corporation has 5.8 million shares outstanding and shares are trading for $20

Calculate the following for 2006. (30PTS, Two Points Each)

Quick Ratio

Current Ratio

Market to Book Ratio

Debt to Equity Ratio

Enterprise Value

EPS

Operating Margin

Net Profit Margin

Return on Equity

P/E Ratio

Inventory Turnover

Days of Sales Outstanding

ROA

ROE

Did the tax rate increase from 2005 to 2006? If so, by how much?

Go to finance.yahoo.com and lookup BABA (Alibaba Group Holding Ltd). What are the following numbers? (5 PTS)

Share Price (2.5PTS)

Total Cash Per Share (under Key Statistics) (2.5PTS)

Analyze the following table to answer the questions

	Product 1
Inventory	200
Project Sales for Oct, 2014	1,000
Actual Sales for Oct, 2014	800
Project Sales for Nov, 2014	1,200

Minimum inventory is set at 10%.

How many units of Product 1 should be manufactured? (10 PTS)

James makes $180,000 a year ($15,000 a month). He pays 27% in taxes and his living expenses are $8,000 a month. He wants to invest the remaining for 30 years at 5%. How much will his portfolio be after 30 years? NOTE that he contributes every month into his portfolio. (10 PTS)

Susanne invests $8,000 now and again towards the end of year 3. She gets a following return for 6 years.

Year	0	1	2	3	4	5	6
Cash Flow		1,000	2,000	4,000	4,000	5,000	5,000

Assume Discount rate is 8%, answer the following (15 PTS)

What is the Net Present Value of these cash flows? Should Susanne make invest in this opportunity? -(5 PTS)

What is the future value of Net Cash Flow (end of year 6) - (5 PTS)

If Susanne had another opportunity where her NPV would be $2000. What is her opportunity cost? - (5 PTS)

Edward signs a 30 year mortgage at 3.5% compounded monthly. The price of his house is $200,000. He makes a down payment of 40,000. Answer the following: (15 PTS)

What will be his monthly payments? (5 PTS)

After 5 years, he makes a one-time payment of $50,000 (against the remaining principle). How many months will he have remaining on his mortgage? To avoid any confusion, he will have exactly 25 years remaining before he makes the $50,000 in payment. (5 PTS)

onsEdwards decides that instead of reducing the NPER after making the $50,000, he requests the bank to keep the NPER to 25 years and reduce his monthly payment instead. What will be his monthly payment going forward? (5 PTS)