FIN 650 Grand Canyon University Accounting Minitap Excel Worksheet Questions
1. Holly's Art Galleries recently reported $7.9 million of net income. Its EBIT was $15 million, and its federal tax rate was 21% (ignore any possible state corporate taxes). What was its interest expense? (Hint: Write out the headings for an income statement and then fill in the known values. Then divide $7.9 million net income by 1 − T = 0.79 to find the pre-tax income. The difference between EBIT and taxable income must be the interest expense.) Enter your answer in dollars. For example, an answer of $1.2 million should be entered as 1,200,000. Round your answer to the nearest dollar.4. Vigo Vacations has $300 million in total assets, $6 million in notes payable, and $33 million in long-term debt. What is the debt ratio? Do not round intermediate calculations. Round your answer to the nearest whole number.5. Reno Revolvers has an EPS of $1.70, a free cash flow per share of $4.40, and a price/free cash flow ratio of 6.0. What is its P/E ratio? Do not round intermediate calculations. Round your answer to two decimal places.6. Needham Pharmaceuticals has a profit margin of 3% and an equity multiplier of 2.1. Its sales are $150 million and it has total assets of $60 million. What is its return on equity (ROE)? Do not round intermediate calculations. Round your answer to two decimal places.7. Assume you are given the following relationships for the Haslam Corporation:Sales/total assets1.4Return on assets (ROA)4%Return on equity (ROE)6%Calculate Haslam's profit margin and liabilities-to-assets ratio. Do not round intermediate calculations. Round your answers to two decimal places.Profit margin: %Liabilities-to-assets ratio: %Suppose half of its liabilities are in the form of debt. Calculate the debt-to-assets ratio. Do not round intermediate calculations. Round your answer to two decimal places. %8. Current and Quick RatiosThe Nelson Company has $1,605,000 in current assets and $535,000 in current liabilities. Its initial inventory level is $370,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? Do not round intermediate calculations. Round your answer to the nearest dollar.$ What will be the firm's quick ratio after Nelson has raised the maximum amount of short-term funds? Do not round intermediate calculations. Round your answer to two decimal places.9. Times-Interest-Earned RatioThe Morrit Corporation has $900,000 of debt outstanding, and it pays an interest rate of 10% annually. Morrit's annual sales are $6 million, its average tax rate is 25%, and its net profit margin on sales is 6%. 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 Morrit's TIE ratio? Do not round intermediate calculations. Round your answer to two decimal places.10. What is the future value of a 6%, 5-year ordinary annuity that pays $400 each year? Do not round intermediate calculations. Round your answer to the nearest cent.$ If this were an annuity due, what would its future value be? Do not round intermediate calculations. Round your answer to the nearest cent.$ 11. Present and Future Values of Single Cash Flows for Different Interest RatesUse both the TVM equations and a financial calculator to find the following values. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d, and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent.An initial $200 compounded for 10 years at 5%.$ An initial $200 compounded for 10 years at 10%.$ The present value of $200 due in 10 years at a 5% discount rate.$ The present value of $200 due in 10 years at a 10% discount rate.$ ____________________12. Uneven Cash Flow StreamFind the present values of the following cash flow streams. The appropriate interest rate is 9%. (Hint: It is fairly easy to work this problem dealing with the individual cash flows. However, if you have a financial calculator, read the section of the manual that describes how to enter cash flows such as the ones in this problem. This will take a little time, but the investment will pay huge dividends throughout the course. Note that, when working with the calculator's cash flow register, you must enter CF0 = 0. Note also that it is quite easy to work the problem with Excel, using procedures described in the Ch04 Tool Kit.xlsx.) Do not round intermediate calculations. Round your answers to the nearest cent.YearCash Stream ACash Stream B1$100$3002 400 4003 400 4004 400 4005 300 100Stream A: $ Stream B: $ What is the value of each cash flow stream at a 0% interest rate? Round your answers to the nearest dollar.Stream A $ Stream B $ 13. While Mary Corens was a student at the University of Tennessee, she borrowed $16,000 in student loans at an annual interest rate of 8%. If Mary repays $1,700 per year, then how long (to the nearest year) will it take her to repay the loan? Do not round intermediate calculations. Round your answer to the nearest whole number. year(s)14. Reaching a Financial GoalYou need to accumulate $10,000. To do so, you plan to make deposits of $1,200 per year - with the first payment being made a year from today - into a bank account that pays 7% annual interest. Your last deposit will be less than $1,200 if less is needed to round out to $10,000. How many years will it take you to reach your $10,000 goal? Do not round intermediate calculations. Round your answer up to the nearest whole number. year(s)How large will the last deposit be? Do not round intermediate calculations. Round your answer to the nearest cent.$