Cranberry Corporation has $3,444,000 of current year taxable income. Use Corporate tax rate schedule.

If the current year is a calendar year ending on December 31, 2017, calculate Cranberry's regular income tax liability.

If the current year is a calendar year ending on December 31, 2018, calculate Cranberry’s regular income tax liability.

If the current year is a fiscal year ending on April 30, 2018, calculate Cranberry's regular income tax liability. (Do not round intermediate calculations.)

The Birdstrom Co. just recently paid a dividend of $2.00 per share. Stock market analysts expect that the growth rate for the dividend will be 40% in year 1, 30% in year 2, 20% in year 3, 15% in year 4, and 10% in year five. After the fifth year, the dividend will grow at a constant rate of 6%. If the required return for Birdstrom is 12%, calculate the current stock price and the expected dividend yield and capital gain in the first year if you buy the stock at the computed price

Nippon Steel’s expenses for heating and cooling a large manufacturing facility are expected to increase according to an arithmetic gradient beginning in year 2. If the cost is $550,000 this year (year 0) and will be $550,000 again in year 1, but then it is estimated to increase by $41,000 each year through year 12, what is the equivalent annual worth in years 1 to 12 of these energy costs at an interest rate of 11% per year? The equivalent annual worth is determined to be?

help with excel formulas to answer this question would be great, thanks.

Inventory Valuation and Earnings
Santiago, Inc., began operations as an importer of fine Chilean wine to the United States. Sales and purchase information is provided below.

Santiago, Inc., uses the LIFO method of inventory valuation. The purchase amount for Year 3 has been left blank because the company has not yet decided the total number of units to purchase during the year. (Assume that all sales occur on the last day of the year, after all purchases for the year have been made. The company’s year-end is December 31.)

Required

How many units should be purchased in Year 3 if the firm’s objective is to minimize income taxes for the year?

Answer

Compute the cost of goods sold for Year 3 assuming that the number of units computed in (1) is purchased.

$Answer

How many units should be purchased in Year 3 if the firm’s objective is to maximize reported income for the year?

Answer

Compute the cost of goods sold for Year 3 assuming that the number of units computed in (3) is purchased.

$Answer

1. Managers of CVS Pharmacy are considering a new project. This project would be a new store in Odessa, Texas. They estimate the following expected net cash flows if the project is adopted.

• Year 0: ($1,250,000)
• Year 1: $200,000
• Year 2: $500,000
• Year 3: $400,000
• Year 4: $300,000
• Year 5: $200,000

Suppose that the appropriate discount rate for this project is 6.7%, compounded annually.

Calculate the net present value for this proposed project.

Do not round at intermediate steps in your calculation. Round your answer to the nearest dollar. If the NPV is negative, include a minus sign. Do not type the $ symbol.

2. Managers at Terlingua Drilling identify a potential new drilling project. They estimate the following expected net cash flows if the project is adopted.

• Year 0: ($1,250,000)
• Year 1: $100,000
• Year 2: $400,000
• Year 3: $400,000
• Year 4: $200,000
• Year 5: $200,000
• Year 6: $300,000
• Year 7: $100,000

Suppose that the appropriate discount rate for this project is 12%, compounded annually.

Calculate the net present value for this proposed project.

Do not round at intermediate steps in your calculation. Round your answer to the nearest dollar. If the NPV is negative, include a minus sign. Do not type the $ symbol.

Hanna, who is a 5-year-old girl, eats nothing but pasta, yogurt, and lemonade. Each month her parents buy 25 pounds of pasta, 65 packages of yogurt, and 15 bottles of lemonade. These three items make up a basket of goods and services similar to the much larger basket used by the Bureau of Labor Statistics (BLS) when computing the official Consumer Price Index (CPI). The table below lists the average price for each item in this basket for the past four years.Hanna's Meals

Instructions: Round your answers to two decimal places.

a. For each year, calculate the CPI, using year 1 as the base year.

     In year 1, the CPI was 100.00 Correct

     In year 2, the CPI was 109.30 Incorrect

     In year 3, the CPI was 109.30 Incorrect

     In year 4, the CPI was 113.19 Correct

b. For each year, calculate the CPI, using year 3 as the base year.

     In year 1, the CPI was 91.72 Correct

     In year 2, the CPI was 100.00 Correct

Haas Company manufactures and sells one product. The following information pertains to each of the company’s first three years of operations:

During its first year of operations, Haas produced 60,000 units and sold 60,000 units. During its second year of operations, it produced 75,000 units and sold 50,000 units. In its third year, Haas produced 40,000 units and sold 65,000 units. The selling price of the company’s product is $57 per unit.

Required:

1. Compute the company’s break-even point in unit sales.

2. Assume the company uses variable costing:

a. Compute the unit product cost for Year 1, Year 2, and Year 3.

b. Prepare an income statement for Year 1, Year 2, and Year 3.

3. Assume the company uses absorption costing:

a. Compute the unit product cost for Year 1, Year 2, and Year 3.

b. Prepare an income statement for Year 1, Year 2, and Year 3.

.

Zola Company manufactures and sells one product. The following information pertains to the company’s first year of operations:

The company does not incur any variable manufacturing overhead costs or variable selling and administrative expenses. During its first year of operations, Zola produced 18,500 units and sold 14,800 units. The selling price of the company’s product is $51.30 per unit.

Required:

1. Assume the company uses super-variable costing:

a. Compute the unit product cost for the year.

b. Prepare an income statement for the year.

Havana Inc. has identified an investment project with the following cash flows. If the discount rate is 9 percent, what is the future of these cash flows in year 6?

Year 1: $910

Year 2: $1140

Year 3: $1360

Year 4: $2100

s.

Can you and your team prepare the income statement table, the operating cash flow (OCF) table, and the total cash flow from assets (CFFA) table for this project?