Please solve the following problems using Excel: 1. Bader started a bakery with a capital of KD75,000. He expects to receive the following annual cash flow for the next five years: KD10,000, KD12,000, KD15,000, KD 20,000, KD24,000. Find the followings by using excel: a. The IRR for the investment. b. The net present value if the interest rate is 8%. c. What will be the annual cash flow if the IRR is 10%. ( use goal seek and show steps) 2. For the attached Balance sheet and Income statement calculate the following ratios: a. Current ratio. b. Quick ratio. c. Return on asset. d. Return on sales. e. Return on equity. (also using excell please and show steps)

Assets

Current

Cash $20,500

Account receivable 18,700

Inventories 52,000

Total current assets $91,200

Fixed Land $25,000

Building and equipment 100,000

Total fixed assets 125,000

Total assets $216,200

Liabilities Accounts payable $15,000

Dividends payable 2,000

Long term notes payable 16,000

Total liabilities $33,000

Net worth Common stock $275,000

Preferred stock 100,000

Retained earnings 20,000

Total net worth 395,000

Total liabilities and net worth $428,000

XYZ Corporation

Income statement 31 Jan., 2014

Revenues

Sales $505,000

Interest revenue 4,000

Total Revenues 509,000

Expenses Cost of goods sold $300,000

Selling 28,000

Administrative 35,000

other 12,500

Total expenses 375,500

Income before taxes 133,500

Taxes for year 50,000

Net profit after taxes $83,500

please show steps on how to calculate for each