Questions
Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment...

Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.32 million. The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which time it will be worthless. The project is estimated to generate $1.735 million in annual sales, with costs of $650,000. The project requires an initial investment in net working capital of $250,000, and the fixed asset will have a market value of $180,000 at the end of the project. The tax rate is 21 percent.

a. What is the project’s Year 0 net cash flow? Year 1? Year 2? Year 3? (Do not round intermediate calculations. Enter your answers in dollars, not millions of dollars, e.g., 1,234,567. A negative answer should be indicated by a minus sign.)
b. If the required return is 12 percent, what is the project's NPV? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)


a.Year 0

Year 1

Year 2

Year 3

b.NPV

In: Finance

What is the effective annual rent for Lease 1 and Lease 2? When you compute the...

  1. What is the effective annual rent for Lease 1 and Lease 2? When you compute the answer, assume the annual discount rate is 7%. Also assume annual rents are paid once per year.

    1. Lease 1 is 5 years. The base rent in 2020 is $13.50 per square foot per year. Each year, the base rent increases by $0.50 per year.

Lease 2 is 6 years. The base rent in 2020 is $13.00 per square foot per year. Each year, the base rent increases by 5% per year.

  1. You own a building with 100,000 leasable square feet. One tenant rents 60,000 square feet and the other 40,000 square feet are vacant. The utilities bill for the year was $80,000. The fixed cost of utilities is $25,000 per year.  

    1. A new tenant enters the building and rents 10,000 square feet. What is the new utilities bill of the building?  

The new tenant has a base stop of $0.80 per square foot. What are recoveries for utilities from this tenant?

In: Finance

Your company has launched a new insurance product and is projecting the premium cashflows, for budgeting...

Your company has launched a new insurance product and is projecting the premium cashflows, for budgeting purposes. You expect to steadily acquire new clients over the first year at a constant rate, and are projecting having 1,000 clients by the end of the year. Each client pays an annual premium of $10 in the first year.

The company expects slower growth in clients in Years 2 and 3, with 500 new clients in Year 2, and 200 new clients in Year 3. They also expect some lapses, whereby 10% of those who paid the premium in their first year do not make the second year of payments. Premiums will remain fixed at $10 per year for the three year period.

Define ?(?) as the total premium paid between time 0 and time ?.

  1. Derive the expression(s) for ?(?) for the period ? = 0 through to ? = 3.
  2. If there is a constant force of interest of 5% over the three years, write down the expression for the present value of this stream of premium payments.

M(t) is the total premium paid between time 0 and time t

In: Finance

Top-Ten Inc. is considering replacing its existing machine that is used to produce musical CDs. This...

Top-Ten Inc. is considering replacing its existing machine that is used to produce musical CDs. This existing machine was purchase 3 years ago at a base price of $50,000. Installation costs at the time for the machine were $1,000. The existing machine is considered a 3-year class for MACRS. The existing machine can be sold today for $40,000 and for $10,000 in 3 years. The new machine has a purchase price of $90,000 and is also considered a 3-year class for MACRS. Installation costs for the new machine are $7,000. The estimated salvage value of the new machine is $30,000. This new machine is more efficient than the existing one and thus savings before taxes using the new machine are $8,000 a year. The company's marginal tax rate is 30% and the cost of capital is 12%. For this project, what is the incremental cash flow in year 1?

MACRS Fixed Annual Expense Percentages by Recovery Class

3 Year MACRS percentages

Year 1= 33.33%

Year 2=44.45%

Year 3=14.81%

Year 4=7.41%

In: Finance

Down Under Boomerang, Inc., is considering a new three-year expansion project that requires an initial fixed...

Down Under Boomerang, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $2.64 million. The fixed asset falls into the three-year MACRS class. The project is estimated to generate $2,060,000 in annual sales, with costs of $759,000. The project requires an initial investment in net working capital of $280,000, and the fixed asset will have a market value of $270,000 at the end of the project.
  
If the tax rate is 35 percent, what is the project’s Year 1 net cash flow? Year 2? Year 3? Table 8.3. (Enter your answers in dollars, not millions of dollars. A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 1,234,567.89.)

Cash Flow
Year 0 $
Year 1 $
Year 2 $
Year 3 $


If the required return is 13 percent, what is the project's NPV? (Enter your answer in dollars, not millions of dollars. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 1,234,567.89.)
  
NPV           $

In: Finance

Project cash flow and NPV. The managers of Classic Autos Incorporated plan to manufacture classic Thunderbirds...

Project cash flow and NPV. The managers of Classic Autos Incorporated plan to manufacture classic Thunderbirds (1957 replicas). The necessary foundry equipment will cost a total of $4,200,000 and will be depreciated using a five-year MACRS life rate. The sales manager has an estimate for the sale of the classic Thunderbirds. The annual sales volume will be as follow:

Year one: 260 Year four: 380

Year two: 290 Year five: 300

Year three: 330


If the sales price is $30,000 per car, variable costs are $18,000 per car, and fixed costs are $1,200,000 annually, what is the annual operating cash flow if the tax rate is 30%?

The equipment is sold for salvage for $500,000 at the end of year five. Net working capital increases by $500,000 at the beginning of the project? (year 0) and is reduced back to its original level in the final year. Find the internal rate of return for the project using the incremental cash flows. (Hint: Find the annual operating cash flow of the project for years 1-5 and making an income statement)?

In: Finance

Required information [The following information applies to the questions displayed below.] Oak Mart, a producer of...

Required information

[The following information applies to the questions displayed below.]

Oak Mart, a producer of solid oak tables, reports the following data from its second year of business.

Sales price per unit $ 320 per unit
Units produced this year 115,000 units
Units sold this year 118,250 units
Units in beginning-year inventory 3,250 units
Beginning inventory costs
Variable (3,250 units × $135) $ 438,750
Fixed (3,250 units × $80) 260,000
Total $ 698,750
Manufacturing costs this year
Direct materials $ 42 per unit
Direct labor $ 64 per unit
Overhead costs this year
Variable overhead $ 3,400,000
Fixed overhead $ 7,400,000
Selling and administrative costs this year
Variable $ 1,500,000
Fixed 4,000,000

2. Prepare the current-year income statement for the company using absorption costing.

OAK MART COMPANY
Absorption Costing Income Statement
Beginning inventory
Manufacturing costs this year
Net income (loss)
Fixed costs added to(subtracted from) inventory

In: Accounting

Cornerstone Exercise 8.11 (Algorithmic) Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and...

Cornerstone Exercise 8.11 (Algorithmic)
Cash Receipts Budget and Accounts Receivable Aging Schedule

Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales:

Quarter 1 $4,700,000
Quarter 2 5,230,000
Quarter 3 6,680,000
Quarter 4 8,590,000

In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,710,000 and for the fourth quarter of the current year are $7,170,000.

Required:

1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year.

Quarter Cash Sales Credit Sales
3, current year $ $
4, current year
1, next year
2, next year
3, next year
4, next year

2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. If an amount is zero, enter "0".


Shalimar Company

Cash Receipts Budget

For the Coming Year

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Cash sales

$

Correct 9 of Item 2

$

Correct 10 of Item 2

$

Correct 11 of Item 2

$

Correct 12 of Item 2

Received on account from:

Quarter 3, current year

Correct 15 of Item 2

Quarter 4, current year

Correct 17 of Item 2

Correct 18 of Item 2

Quarter 1, next year

Correct 20 of Item 2

Correct 21 of Item 2

Correct 22 of Item 2

Quarter 2, next year

Correct 24 of Item 2

Correct 25 of Item 2

Correct 26 of Item 2

Quarter 3, next year

Correct 28 of Item 2

Correct 29 of Item 2

3. What if the recession led Shalimar’s top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.


Shalimar Company

Cash Receipts Budget

For the Coming Year

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Cash sales

$

Correct 9 of Item 3

$

Correct 10 of Item 3

$

Correct 11 of Item 3

$

Correct 12 of Item 3

Received on account from:

Quarter 4, current year

Correct 15 of Item 3

Quarter 1, next year

Correct 17 of Item 3

Correct 18 of Item 3

Quarter 2, next year

Correct 20 of Item 3

Correct 21 of Item 3

Quarter 3, next year

Correct 23 of Item 3

Correct 24 of Item 3

Quarter 4, next year

Correct 26 of Item 3

Total cash receipts

$

Correct 28 of Item 3

$

Correct 29 of Item 3

$

Correct 30 of Item 3

$

Quarter 4, next year

Correct 31 of Item 2

Correct 32 of Item 2

Correct 33 of Item 2

Correct 34 of Item 2

Total cash receipts

$

Correct 36 of Item 2

$

Correct 37 of Item 2

$

Correct 38 of Item 2

$

In: Finance

Prepare an amortization sxhedule for a three-year loan of $12,000. The interest rate is 7% per...

Prepare an amortization sxhedule for a three-year loan of $12,000. The interest rate is 7% per year, and the loan calls for equal annual end-of-year payments.

In: Finance

What is the present value of the payment stream discounted at 5% annually: $1000 at the...

What is the present value of the payment stream discounted at 5% annually: $1000 at the end of year 1, -$2000 at the end of year 2, and $3000 at the end of year 3? Also calculate future value of the cash flows at the end of year 3. Financial calculator not allowed for this question. Show all work!

In: Finance