Question

Your company is undertaking a new project. A building was purchased 10 years ago for $750,000...

Your company is undertaking a new project. A building was purchased 10 years ago for $750,000 depreciated straight line to $150,000 (the land value) over 30 years. It is now worth $500,000 (including $150,000 land). The project requires improvements to the building of $100,000. The improvements are depreciated straight line to zero over the life of the project. The project will generate revenues of $325,000, $350,000, $375,000 and $400,000 for years 1-4, respectively. Annual cash operating expenses are $80,000, $100,000, $120,000 and $140,000, respectively. The project will last 4 years, at which time the building will be sold for $600,000. Taxes are 40% and rate of return is 10%. Using Excel, prepare a spreadsheet and upload: 1. What is the total depreciation per year? 2.. Show projected annual income statements. 3.. What is the initial cost (CF0)? 4. What are annual operating Cash Flows? 5. What is the ending Cash Flow from the sales of the assets? 6. What is the total annual Cash Flows? 7. What is NPV? Show work 8. What is Profitability Index? Show work. (at least 2 decimals) 9. What is payback in whole years? 10. What is Average Accounting Return? (correct format with at least 2 decimals) 11. Show how (algebraic format), IRR would be solved (do not solve).

Homework Answers

Answer #1

1. Total depreciation per year = Cost of Improvement - Depreciated Value / Life of asset = (100000 - 0) / 4 = $ 25,000 (Since existing building is fully depreciated, its depreciation is ignored)

2. Projected annual income statements.

Year Cash Revenues Cash Expenses EBDT (Revenue - Expenses) Depreciation EBT taxes@40% EAT
1 325000 80000 245000 25000 220000 88000 132000
2 350000 100000 250000 25000 225000 90000 135000
3 375000 120000 255000 25000 230000 92000 138000
4 400000 140000 260000 25000 235000 94000 141000
3. Initial cost(CFO) = Cost of Improvemnt = $ 100,000

4. Annual operating cash flows

Cash Flow = EAT + Depreciation

EAT Add Depreciation Cash Inflow
132000 25000 157000
135000 25000 160000
138000 25000 163000
141000 25000 166000

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
your company is undertaking a new project. a building was purchased 10 years ago for$ 750,000...
your company is undertaking a new project. a building was purchased 10 years ago for$ 750,000 depreciated straight line to $150,000( the land value) over 30 years. it is now worth $500,000( including $150,000 land).the project requires improvements to the building of $100,000 the improvements are depreciated straight line to zero over the life of the project. the project will generate revenues of $325,000$350,000$375,000$400,000 for years 1-4 respectively. Annual cash operating expenses are $80,000$100,000$120,000and $140,000, respectively. the project will last...
a building was purchased 5 years ago for 1,000000$ depreciated straight line to 100000$ (land value)...
a building was purchased 5 years ago for 1,000000$ depreciated straight line to 100000$ (land value) over 30 years. its now worth 600000$ (including 100000$ land). the project requires improvement to the building of 200,000$. the improvement are depreciated straight line to zero over the life of the project. the project wil generate revenues of 325000$, 350000$, 375000$ and 400000$ for years 1-4.. Annual cahs operating expenses are 180000$, 200000$,220000$ and 240000$. the project will last 4 years at which...
Your company is considering a new project, and you have the following information: Two years ago,...
Your company is considering a new project, and you have the following information: Two years ago, the company paid $1,000,000 for the land and building that will house the project. The property could be sold for $3,000,000 today. Its book value is the purchase price. One year ago, the firm spent $100,000 on initial marketing for the project. The project requires the purchase of a machine (in year 0) for $500,000. The machine will be fully depreciated straight-line in years...
A company is considering a new project. The project will generate $200,000 in revenues and $110,000...
A company is considering a new project. The project will generate $200,000 in revenues and $110,000 in operating costs each year for the next 5 years. It would require an additional investment of $150,000 to be depreciated to a zero book value on a straight line basis over 5 years. The investment has a salvage value of $20,000. The tax rate is 40%. At the end of year 5, there is a $10,000 return of networking capital. Determine the annual...
A new expansion project will produce operating cash flows of $90,000 a year for four years....
A new expansion project will produce operating cash flows of $90,000 a year for four years. During the life of the project, inventory will increase by $35,000 and accounts receivable will decrease by $10,000. Accounts payable will increase by $15,000, and wages payable will increase by $5,000. At the end of the project, net working capital will return to its normal level. The project requires the purchase of equipment at an initial cost of $70,000. Equipment delivery and installation costs...
A project requires an initial investment of $300,000 and expects to produce an after-tax operating cash...
A project requires an initial investment of $300,000 and expects to produce an after-tax operating cash flow of $150,000 per year for three years. The asset value will be depreciated using straight-line depreciation over three years. At the end of the project, the asset could be sold for a price of $100,000. Assume a 21% tax rate and 15% cost of capital. Calculate the NPV of the project. Excel format please.
You are considering a 10-year project: An initial investment (today) in equipment of $900,000 is required....
You are considering a 10-year project: An initial investment (today) in equipment of $900,000 is required. There will be no salvage value for this equipment after 10 years. The equipment is depreciated using the straight-line method, $90,000/year for 10 years. Annual expected revenues are $700,000/year for 10 years (beginning 1 year from today). Annual expected operating expenses are $250,000/year for 10 years (beginning 1 year from today). This $250,000 does not include depreciation. The tax rate is 35%. An investment...
Your company purchased a piece of land five years ago for $150,000 and subsequently added $175,000...
Your company purchased a piece of land five years ago for $150,000 and subsequently added $175,000 in improvements. The current book value of the property is $225,000. There are two options for future use of the land: 1) the land can be sold today for $450,000 on a net after-tax basis; 2) your company can destroy the past improvements and build a factory on the land. In consideration of the factory project, what amount (if any) should the land be...
Problem 2 Whitehall Co. has the opportunity to introduce a new product. Whitehall expects the project...
Problem 2 Whitehall Co. has the opportunity to introduce a new product. Whitehall expects the project to sell for ₱40 and to have per-unit variable costs of ₱27 and annual cash fixed costs of ₱1,500,000. Expected annual sales volume is 200,000 units. The equipment needed to bring out the new product costs ₱3,500,000, has a fouryear life and no salvage value, and would be depreciated on a straight-line basis. Whitehall's cutoff rate is 10% and its income tax rate is...
The Green Shingle purchased a parcel of land 6 years ago for $299,500. Since the firm...
The Green Shingle purchased a parcel of land 6 years ago for $299,500. Since the firm wasn't ready to use the site itself at that time, it decided to lease the land for $28,000 a year. The Green Shingle is now considering building a hotel on the site as the rental lease is expiring. The current value of the land is $347,500. The firm has no loans or mortgages secured by the property but would need to spend $64,000 to...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT