Show Work, Please. Excel Preferably. Suppose you are considering investing in a new business that will cost $10 million. A bank is willing to lend you $7 million for the purchase with equity holders having to provide the remainder of the funds. the terms of the loan are: a 20-year loan with yearly payments at a fixed rate of 3%. You will sell the business after year 8. You estimate the business will have the following profits in years 1-8: $100,000 in year 1, $300,000 in year 2, and $400,000 year 3 through year 8. In year 8, and advisor tells you that given the expectation of increased competition that the business will likely only sell for $15 million at the end of year 8( ignore any tax issues).

a.) Calculate the return to equity holders if they provide the funds that the bank does not provide.

b.) Now that your equity investors have heard about the "evils of leverage" and refuse to borrow any money from the bank, calculate the return assuming equity holders put up the entire $10 million purchase price.

c.) Based upon your answers in a) and b), what are the benefits of leverage( borrowing money to finance purchase)? What other benefits of leverage are there to investors? Why might leveraging be bad?

What are the two main financial reporting standards currently being used by companies? Do all companies have to use these financial reporting standards?

APA Format, 4 cited sources

1) Archer Company has total sales of $397,000, costs are $284,000, and depreciation is $35,200. The tax rate is 25 percent. The firm does not have any interest expense. What is the operating cash flow?

2)At the beginning of the year, Calpine, Inc. had current assets of $863,000 and current liabilities of $827,000. At the end of the year, the current assets are $978,000 and the current liabilities are $953,000. What is the change in net working capital?

3) Corning Company has total sales of $638,000, costs are $471,000, and depreciation is $43,000. The tax rate is 25 percent. The interest expense is $35,000. What is the operating cash flow?

4)Dole Food had beginning net fixed assets of $486,000 and ending net fixed assets of $501,000. Assets valued at $42,000 were sold during the year. Depreciation was $35,800. What is the amount of net capital spending?

5)At the beginning of the year, long-term debt of Healthnet is $595,000 and total debt is $647,000. At the end of the year, long-term debt is $619,000 and total debt is $682,000. The interest paid is $30,100. What is the amount of the cash flow to creditors?

Prepare a memo to management that explains how and why data analysis is used in the various stages of the audit process, including the risk assessment stage, the determination of sampling method and audit universe, the substantive procedures stage, and the end of the audit.

Specifically, the following critical elements must be addressed:

1. Data Analysis: Risk Assessment Stage: Explain how and why data analysis is used at the risk assessment stage of the audit process.

2. Data Analysis: Determination of sampling method and audit universe: Explain how data analysis is used in the determination of sampling method and audit universe.

3. Data Analysis: Substantive procedures stage: Explain how and why data analysis is used at the substantive procedures stage of the audit.

4. Data Analysis: End of audit: Explain how and why data analysis is used near the end of an audit.

You’ve collected the following information about Erna, Inc.: Sales = $ 335,000 Net income = $ 18,800 Dividends = $ 7,600 Total debt = $ 71,000 Total equity = $ 102,000 What is the sustainable growth rate for the company? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Sustainable growth rate? % Assuming it grows at this rate, how much new borrowing will take place in the coming year, assuming a constant debt–equity ratio? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Additional borrowing? What growth rate could be supported with no outside financing at all? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Growth rate? %

The cost of debt   Gronseth Drywall​ Systems, Inc., is in discussions with its investment bankers regarding the issuance of new bonds. The investment banker has informed the firm that different maturities will carry different coupon rates and sell at different prices. The firm must choose among several alternatives. In each​ case, the bonds will have1,000 par value and flotation costs will be $30 per bond. The company is taxed at 23​%.

Use the approximation formula to calculate the ​after-tax cost of financing with the following alternative.  ​(Click on the icon located on the​ top-right corner of the data table below in order to copy its contents into a​ spreadsheet.)

The​ after-tax cost of financing using the approximation formula is _____.

​(Round to two decimal​ places.)

Consider the three stocks in the following table. P_t represents price at time t, and Q_t represents shares outstanding at time t. Stock C splits two-for-one in the last period.

a. Calculate the rate of return on a price-weighted index of the three stocks for the first period (t = 0 to t = 1). (Do not round intermediate calculations. Round your answer to 2 decimal places.)

b. What will be the divisor for the price-weighted index in year 2? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

c. Calculate the rate of return of the price-weighted index for the second period (t = 1 to t = 2).

Any advice or recommendation would be greatly appreciated

You are the sport agent for a rising basketball star just drafted in the first round. Your client has two offers on the table option

1. $90 million dollars over 5 years or option
2. $30 million signing bonus and 40 million over the next 3 yrs.

What option do you recommend? How does the time value of money impact your decision?

A $5000 investment today will return $1,313 each year for the next four years with the first payment starting in one year. The NPV of this investment is negative at your required return of 2.5%. Which of the following is closest to the internal rate of return on this project?

You observe the exchange rates from the following 4 currencies(US, EU, UK, and Japan):

a.$1.19/€, $1.30/£, $0.0091/¥

b.€0.84/$, €1.09/£, €0.0076/¥

c.£0.77/$, £.91/€, £0.0055/¥

d.¥110.27/$, ¥130.77/¥, 183.26/£

Suppose that you incur 2% transaction costs. That is, if you attempt to convert one currency to another, you only get 98% of the quoted rate. So with €1, you can get .98*$1.19 = $1.17 There is an arbitrage opportunity in this market. Find it and describe each transaction you would take to exploit it. If a large amount of money went through this process, this would exert pressure on these exchange rates. For each transaction in your arbitrage strategy, explain how that transaction would impact currency values.

Problem 3-6 Financial Statements (LO1,4)

South Sea Baubles has the following (incomplete) balance sheet and income statement.

a&b. What is shareholders’ equity in 2015 and 2016? (Enter your answers in millions.)

c&d. What is net working capital in 2015 and 2016? (Enter your answers in millions.)

e. What are taxes paid in 2016? Assume the firm pays taxes equal to 35% of taxable income. (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.)

f. What is cash provided by operations during 2016? (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.)

g. Net fixed assets increased from $900 million to $1,000 million during 2016. What must have been South Sea’s gross investment in fixed assets during 2016? (Enter your answer in millions.)

Problem 3-24 Free Cash Flow (LO3)

The following table shows an abbreviated income statement and balance sheet for Quick Burger Corporation for 2016.

In 2016 Quick Burger had capital expenditures of $3,057.

a. Calculate Quick Burger’s free cash flow in 2016. (Enter your answer in millions.)

b. If Quick Burger was financed entirely by equity, how much more tax would the company have paid? (Assume a tax rate of 35%.) (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.)

c. What would the company’s free cash flow have been if it was all-equity financed?

Convertible bond vs straight fixed-rate bond.

Which bond has a higher demand, higher risk, and price ceteris paribus.

Problem 3-7 Financial Statements (LO1)

Here are the 2015 and 2016 (incomplete) balance sheets for Newble Oil Corp.

a&b. What was owners’ equity at the end of 2015 and 2016? (Enter your answers in millions.)

c. If Newble paid dividends of $180 million in 2016 and made no stock issues, what must have been net income during the year? (Enter your answer in millions.)

d. If Newble purchased $380 million in fixed assets during 2016, what must have been the depreciation charge on the income statement? (Enter your answer in millions.)

e. What was the change in net working capital between 2015 and 2016? (Enter your answer in millions.)

f. If Newble issued $232 million of new long-term debt, how much debt must have been paid off during the year? (Enter your answer in millions.)

Question 3 – Capital Investment Analysis

The management team of Accent Group Limited have received a proposal from the manager of Hype DC. This proposal concerns a major upgrade to Hype DC's stores to improve the customer experience. Key details relating to this proposal include:

• The initial cost will be $22 million. This cost will be depreciated using the straight line method over the 5 year life of the upgrade.
• During year 1, the firm will increase marketing costs by $2.0 million to promote the store upgrades.
• Over the five year life of the project, it is expected that the upgrade will increase the firm's sales by $18 million per year. On average, cost of sales is 45% of revenue.
• The firm will need to higher additional staff over the life of the project to help to deal with the increased sale volume. In year 1, the firm's staffing costs will increase by $1.0 million. These costs will increase by 3.5% p.a.
• The upgrade is expected to increase the firm's energy costs by $500,000 in year 1. This increase will be ongoing across the life of the project and will increase by 6% p.a.
• Upgraded stores will include an old shoe recycling drop off zone. This recylcing program will cost $75,000 in year 1. These costs will increase by 2% p.a.
• At the end of year 3, the firm will spend $1.5 million on a minor refurbishment to the stores.

The firm’s tax rate is 30%. The firm requires a 16% required rate of return on all potential investments.

Required

In relation to the above proposal:

1. Calculate the annual after tax cash flows and annual after tax profit

(show with workings please)