|
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 answer, assume the annual discount rate is 7%. Also assume annual rents are paid once per year.
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.
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.
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 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 ?.
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 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 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 (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 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.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
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".
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Finance
In: Finance
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