PLEASE ANSWER IN EXCEL!

The Ajax Co. just decided to save $15,000 a year for the next five years as a safety net for recessionary periods. The money will be set aside in a separate savings account which pays 3.25% interest. It deposits the first $15,000 today. How much would the company end up with, in this saving account, at the end of the 5 year? The Ajax Co. just decided to save $15000 a year for the next five years as a safety net for recessionary periods. The money will be set aside in a separate savings account which pays 3.25% interest. It deposits the first $15000 today. How much would the company end up with, in this saving account, at the end of the 5 year?

You have an opportunity to invest $102000 now in return for $80200 in one year and $29400 in two years. If your cost of capital is 9.1% ​, what is the NPV of this​ investment?

A 7-year project is expected to provide annual sales of $153,000 with costs of $89,000. The equipment necessary for the project will cost $275,000 and will be depreciated on a straight-line method over the life of the project. You feel that both sales and costs are accurate to +/-10 percent. The tax rate is 40 percent. What is the annual operating cash flow for the worst-case scenario? a)50994 b)39594 c)68634 d)23880 e)31634

One​ year, the mean age of an inmate on death row was 40.5 years. A sociologist wondered whether the mean age of a​ death-row inmate has changed since then. She randomly selects 32 ​death-row inmates and finds that their mean age is 39.9​, with a standard deviation of 8.9. Construct a​ 95% confidence interval about the mean age. What does the interval​ imply?

LOADING... Click the icon to view the table of critical​ t-values.

Choose the correct hypotheses. Upper H 0​: ▼ ▼ nothing Upper H 1​: ▼ sigma mu x overbar p ▼ less than greater than equals not equals nothing ​(Type integers or decimals. Do not​ round.)

Construct a​ 95% confidence interval about the mean age. With​ 95% confidence, the mean age of a death row inmate is between ? years and ?g years. ​(Round to two decimal places as​ needed.)

What does the interval​ imply? A. Since the mean age from the earlier year is not contained in the​ interval, there is not sufficient evidence to conclude that the mean age had changed. B. Since the mean age from the earlier year is contained in the​ interval, there is sufficient evidence to conclude that the mean age had changed. C. Since the mean age from the earlier year is contained in the​ interval, there is not sufficient evidence to conclude that the mean age had changed. D. Since the mean age from the earlier year is not contained in the​ interval, there is sufficient evidence to conclude that the mean age had changed.

Suppose that Dom began a landscaping business in 2020. In that year, he adopted the last-in first-out (LIFO) inventory-flow method for his business inventory of shrubbery by using it for the year on his tax return.

In 2019, he purchased the following four batches of shrubs (total cost per batch below).

   Shrubs         Purchase Date        Direct Cost         Other Inventoriable Costs      Total Cost
      200               July 21                 $ 2,000              $ 200                                $ 2,200

      150              August 15              $ 2,000              $ 100                                $ 2,100
      100             October 30              $ 2,200              $ 400                                $ 2,600
      140            November 10            $ 2,700              $ 100                                $ 2,800

In 2020, Dom sold 200 shrubs. In 2021, Dom purchased three more batches of shrubs at the following total cost per batch below. Just before year end in 2021, he also sold 50 shrubs:

                       Shrubs             Purchase Date               Total Cost
                        100                 Early spring                   $ 2,400
                        125                    Summer                      $ 2,500
                        100                        Fall                         $ 2,600

a.     (10 points) What cost of goods sold and ending inventory would Dom record if he elects to use the LIFO method in 2020?

b.    (10 points) What will be his cost of goods sold and ending inventory in 2021 under the LIFO method?

c.     (10 points) How would you answer (a) change if Dom had initially selected the first-in, first-out (FIFO) method instead of LIFO?

d.    (10 points) How would you answer (b) change if Dom had initially selected the first-in, first-out (FIFO) method instead of LIFO?

An insurance company must make payments to a customer of $12 million in one year and $7 million in four years. The yield curve is flat at 5%.

a. If it wants to fully fund and immunize its obligation to this customer with a single issue of a zero-coupon bond, what maturity bond must it purchase? (Do not round intermediate calculations. Round your answer to 4 decimal places.)

b. What must be the face value and market value of that zero-coupon bond? (Do not round intermediate calculations. Enter your answers in millions rounded to 2 decimal places.)

The Norfolk Company reported the following information at the end of the current year:

Refer to the Norfolk Company, calculate:

1. Manufacturing Overhead cost.
2. Total manufacturing costs.
3. Prime costs.
4. Conversion costs.
5. Period costs.

The Norfolk Company reported the following information at the end of the current year:

Refer to the Norfolk Company, calculate:

1. Manufacturing Overhead cost.
2. Total manufacturing costs.
3. Prime costs.
4. Conversion costs.
5. Period costs.

The following independent situations occurred at the end of Year 2 and require an inventory report in the year-end financial statements. The dollar amounts provided in the table below are on a per-unit basis. In Situation 5., assume that the company is applying IFRS.

Select from the option list provided the appropriate measurement attributes for reporting inventory in the year-end financial statements. Each choice may be used once, more than once, or not at all.

On December 28 each year, you are planning to make a charitable donation of $2320 and are in the 30 percent tax bracket. You are planning to deposit the tax savings in a savings account for the next 17 years at 4 percent, what will be the future value of that savings account?

Use the appropriate Time Value of Money table [Exhibit 1-A,  Exhibit 1-B,  Exhibit 1-C, OR Exhibit 1-D]

(Round your answer to the nearest whole number. Do not include the comma, period, and "$" sign in your response.)

Your Answer: