Please find the answer for the Payback Period, Discounted Payback, NPV, IRR for Project One. Explain how to get the answer
.

PRO FORMA INCOME STATEMENT

At the end of last year, Roberts Inc. reported the following income statement (in millions of dollars):

Looking ahead to the following year, the company's CFO has assembled this information:

• Year-end sales are expected to be 14% higher than the $3 billion in sales generated last year.
• Year-end operating costs, excluding depreciation, are expected to equal 80% of year-end sales.
• Depreciation is expected to increase at the same rate as sales.
• Interest costs are expected to remain unchanged.
• The tax rate is expected to remain at 40%.

On the basis of that information, what will be the forecast for Roberts' year-end net income? Enter your answer in millions. For example, an answer of $25,000,000 should be entered as 25. Round your answer to two decimal places.

$___ million

Frank's Cargo Corp has 100,000 outstanding bonds paying $30 twice a year. Today, the bonds sell for $900 and will mature in five years. If the market rate is 12%, the risk-free rate is 2%, and the marginal tax rate is 30%, what is the cost of debt capital for Frank's Cargo Corp?

Making an investment (FV Function): long term

You told Jane about your calculation result and Jane is very impressed by your ability of using the FV function. She says that she would like to save more. Now she wants to know if she is able to deposit $3,000.00 in a mutual fund account each year as a lump sum, and let it grow for 30 years, how much money would she receive at the end of 30 years.

Before she makes a decision about how much she would deposit for each year, she wants to do a comparison about how the initial deposit amount affect the end result. She figures out that she would be able to make the deposit between $2000 and $5000 each year. She will make the deposit at the beginning of each year.

She asks you to calculate this for her. Since the return (rate) of the mutual fund varies, sometimes it could be negative, we will just assume that the rate varies from 3.5% to 8%. Therefore, in your calculation, you need to include the following annual interest/return rate: 3.5%, 4%, 4.5%, 5%, 5.5%, 6%, 6.5%, 7%, 7.5%, 8%.

For the principal/deposit for each year, you will need to include: $2,000, $3,000, $4,000, $5000.

Use a table to calculate how much Jane would receive at the end of 30 years for different deposit amount and rates.

You must use the FV function.

You must use proper cell reference. You will set up the formula one Excel cell in such a way that you can drag and fill out the rest of the table.

Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them to its chain of retail stores, and has a staff to advise customers and help them set up their new computers. Upton's balance sheet as of December 31, 2016, is shown here (millions of dollars): Cash $ 3.5 Accounts payable $ 9.0 Receivables 26.0 Notes payable 18.0 Inventories 58.0 Line of credit 0 Total current assets $ 87.5 Accruals 8.5 Net fixed assets 35.0 Total current liabilities $ 35.5 Mortgage loan 6.0 Common stock 15.0 Retained earnings 66.0 Total assets $122.5 Total liabilities and equity $122.5 Sales for 2016 were $475 million and net income for the year was $14.25 million, so the firm's profit margin was 3.0%. Upton paid dividends of $5.7 million to common stockholders, so its payout ratio was 40%. Its tax rate was 40%, and it operated at full capacity. Assume that all assets/sales ratios, (spontaneous liabilities)/sales ratios, the profit margin, and the payout ratio remain constant in 2017. Do not round intermediate calculations. If sales are projected to increase by $80 million, or 16.84%, during 2017, use the AFN equation to determine Upton's projected external capital requirements. Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Round your answer to two decimal places. $ million Using the AFN equation, determine Upton's self-supporting growth rate. That is, what is the maximum growth rate the firm can achieve without having to employ nonspontaneous external funds? Round your answer to two decimal places. % Use the forecasted financial statement method to forecast Upton's balance sheet for December 31, 2017. Assume that all additional external capital is raised as a line of credit at the end of the year and is reflected (because the debt is added at the end of the year, there will be no additional interest expense due to the new debt). Assume Upton's profit margin and dividend payout ratio will be the same in 2017 as they were in 2016. What is the amount of the line of credit reported on the 2017 forecasted balance sheets? (Hint: You don't need to forecast the income statements because the line of credit is taken out on last day of the year and you are given the projected sales, profit margin, and dividend payout ratio; these figures allow you to calculate the 2017 addition to retained earnings for the balance sheet without actually constructing a full income statement.) Round your answers to the nearest cent. Upton Computers Pro Forma Balance Sheet December 31, 2017 (Millions of Dollars) Cash $ Receivables $ Inventories $ Total current assets $ Net fixed assets $ Total assets $ Accounts payable $ Notes payable $ Line of credit $ Accruals $ Total current liabilities $ Mortgage loan $ Common stock $ Retained earnings $ Total liabilities and equity $

Filer Manufacturing has 5,336,582 shares of common stock outstanding. The current share price is $27.73, and the book value per share is $8.17. Filer Manufacturing also has two bond issues outstanding. The first bond issue has a face value of $58,377,375, has a 0.05 coupon, matures in 10 years and sells for 83 percent of par. The second issue has a face value of $77,610,198, has a 0.06 coupon, matures in 20 years, and sells for 92 percent of par.

The most recent dividend was $1.69 and the dividend growth rate is 0.05. Assume that the overall cost of debt is the weighted average of that implied by the two outstanding debt issues. Both bonds make semiannual payments. The tax rate is 0.38.

What is Filer's aftertax cost of debt? Enter the answer with 4 decimals

Garlington Technologies Inc.'s 2016 financial statements are shown below:

Balance Sheet as of December 31, 2016

Income Statement for December 31, 2016

Suppose that in 2017 sales increase by 5% over 2016 sales and that 2017 dividends will increase to $170,000. Forecast the financial statements using the forecasted financial statement method. Assume the firm operated at full capacity in 2016. Use an interest rate of 13%, and assume that any new debt will be added at the end of the year (so forecast the interest expense based on the debt balance at the beginning of the year). Cash does not earn any interest income. Assume that the all new-debt will be in the form of a line of credit. Round your answers to the nearest dollar. Do not round intermediate calculations.

I need help to calculate--addition to RE on income statement.....i have calculated the rest of the numbers.

Problem 12-09
Financing Deficit

Garlington Technologies Inc.'s 2016 financial statements are shown below:

Balance Sheet as of December 31, 2016

Income Statement for December 31, 2016

Suppose that in 2017 sales increase by 5% over 2016 sales and that 2017 dividends will increase to $118,000. Forecast the financial statements using the forecasted financial statement method. Assume the firm operated at full capacity in 2016. Use an interest rate of 14%, and assume that any new debt will be added at the end of the year (so forecast the interest expense based on the debt balance at the beginning of the year). Cash does not earn any interest income. Assume that the all new-debt will be in the form of a line of credit. Round your answers to the nearest dollar. Do not round intermediate calculations.

1. Construct profit diagrams at expiration time to show what position in IBM puts, calls and/or underlying stock best expresses the investor’s objectives described below.

   IBM currently sells for $150 so that profit diagrams between $100 and $200 in $10 increments are appropriate. Also assume that at-the-money puts and calls currently

cost $20 each. The call with strike $140 costs $25 and the call with strike $160 costs $17.

1. (a) An investor wants to benefit from IBM price drops, but does not want to lose more than $20 on the investment.

2. (b) An investor wants to capture profits if IBM price declines and losses if IBM price increases. The investor wants to break even if IBM price does not change.

3. (c) An investor wants to bet that the upcoming IBM earnings announcement is very close to market expectations—meaning that the price will not move by more than $10 dollars.

Explain why shareholder wealth as a singular, overarching goal is flawed.

If the Johnson Company just acquired a building for $200,000 through financing from Bank of America at a 5% annual interest rate. 20 years to loan maturity. What would be Johnsons monthly mortgage payment? Round the answer to the nearest whole dollar.

Growth​ Company's current share price is

$ 20.00$20.00​,

and it is expected to pay a

$ 1.30$1.30

dividend per share next year. After​ that, the​ firm's dividends are expected to grow at a rate of

3.9 %3.9%

per year.

a. What is an estimate of Growth​ Company's cost of​ equity?

b. Growth Company also has preferred stock outstanding that pays a

$ 2.25$2.25

per share fixed dividend. If this stock is currently priced at

$ 28.05$28.05​,

what is Growth​ Company's cost of preferred​ stock?

c. Growth Company has existing debt issued three years ago with a coupon rate of

5.7 %5.7%.

The firm just issued new debt at par with a coupon rate of

6.4 %6.4%.

What is Growth​ Company's cost of​ debt?

d. Growth Company has

5.45.4

million common shares outstanding and

1.21.2

million preferred shares​ outstanding, and its equity has a total book value of

$ 49.9$49.9

million. Its liabilities have a market value of

$ 20.4$20.4

million. If Growth​ Company's common and preferred shares are priced at

$ 28.05$28.05

and

$ 20.00$20.00​,

​respectively, what is the market value of Growth​ Company's assets?

e. Growth Company faces a

35 %35%

tax rate. Given the information in parts a through d and your answers to those​ problems, what is Growth​ Company's WACC?

​Note: Assume that the firm will always be able to utilize its full interest tax shield

Which of the following statements relating to bond pricing is false?

Group of answer choices

An indenture is a legal document that spells out the contract between the bondholders and corporation.

Everything else being equal, a bond with 10 years to maturity will sell at a smaller premium or discount than a bond with 5 years to maturity.

A call option on a bond favors the firm rather than the investor.

Everything else being equal, greater differences between the coupon rate and the "required" rate will result in greater premiums or discounts.

A bond with 20 detachable warrants has just been offered for sale at $1000. The bond matures in 15 years and has an annual coupon of $120. Each warrant gives the owner the right to purchase two shares of stock in the company at $17 per share. Ordinary bonds (with no warrants) of similar quality are priced to yield 18%. What is the value of one warrant?

You own a lot in Key West, Florida, that is currently unused. Similar lots have recently sold for $2 million. Over the past five years, the price of land in the area has increased 15% per year, with an annual standard deviation of 22%. A buyer has recently approached you and wants an option to buy the land in the next 9 months for $2,160,000. The risk free rate of interest is 3% per year, compounded continuously. How much do you charge for the option?

a. 193,240.97

b. 101,056.16

c. 111,693.66

d. 106,374.91