I need help with the following excel sheet attached. I am sorry for the short notice, but I had ask for help Friday and the help I got didn't know how to do formulas in excel and it was all worked out manually.

Molteni Motors Inc. recently reported $6 million of net income. Its EBIT was $13 million, and its tax rate was 40%. What was its interest expense? (Hint: Write out the headings for an income statement, and then fill in the known values. Then divide $6 million net income by 1 T = 0.6 to find the pre-tax income. The difference between EBIT and taxable income must be the interest expense. Use this procedure to work some of the other problems.) Kendall Corners Inc. recently reported net income of $3.1 million and depreciation of $500,000. What was its net cash flow? Assume it had no amortization expense. In its most recent financial statements, Del-Castillo Inc. reported $70 million of net income and $900 million of retained earnings. The previous retained earnings were $855 million. How much in dividends did the firm pay to shareholders during the year? Vigo Vacations has $200 million in total assets, $5 million in notes payable, and $25 million in long-term debt. What is the debt ratio? Reno Revolvers has an EPS of $1.50, a cash flow per share of $3.00, and a price/cash flow ratio of 8.0. What is its P/E ratio? Needham Pharmaceuticals has a profit margin of 3% and an equity multiplier of 2.0. Its sales are $100 million and it has total assets of $50 million. What is its ROE? Assume you are given the following relationships for the Haslam Corporation: Sales/total assets 1.2 Return on assets (ROA) 4% Return on equity (ROE) 7% Calculate Haslam's profit margin and liabilities-to-assets ratio. Suppose half its liabilities are in the form of debt. Calculate the debt-to-assets ratio. The Morris Corporation has $600,000 of debt outstanding, and it pays an interest rate of 8% annually. Morris's annual sales are $3 million, its average tax rate is 40%, and its net profit margin on sales is 3%. If the company does not maintain a TIE ratio of at least 5 to 1, then its bank will refuse to renew the loan and bankruptcy will result. What is Morris's TIE ratio? The Nelson Company has $1,312,500 in current assets and $525,000 in current liabilities. Its initial inventory level is $375,000, and it will raise funds as additional notes payable and use them to increase inventory. How much can Nelson's short-term debt (notes payable) increase without pushing its current ratio below 2.0? What will be the firm's quick ratio after Nelson has raised the maximum amount of short-term funds? What is the future value of a 7%, 5-year ordinary annuity that pays $300 each year? If this were an annuity due, what would its future value be