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$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 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(CFO)?

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 flow

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 and $400,000 for years 1-4, respectively. Annual cash operating expenses are $80,000, $100,000,...
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 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.
Jefferson & Sons is evaluating a project that will increase annual sales by $150,000 and annual...
Jefferson & Sons is evaluating a project that will increase annual sales by $150,000 and annual cash costs by $90,000. The project will initially require $100,000 in fixed assets that will be depreciated straight-line to a zero book value over the 5-year life of the project. The applicable tax rate is 40 percent. What is the operating cash flow for this project? a. $11,220 ( ) b. $29,920 ( ) c. $44,000 ( ) d. $46,480 ( ) e. $46,620
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...
The Company is considering a new project of 3 years. The initial investment on the the...
The Company is considering a new project of 3 years. The initial investment on the the machine costs $380,190, and will be depreciated on a straight-line basis to zero over the project life. The machine will become worthless in the end. The project will brings in annual operating cash flow of $220,110. It also requires an additional investment in net working capital of $4,000 initially, which will be fully recovered at the end of the project. The tax rate is...
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...
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...
Pasha Entertainment is evaluating a new project that will have a life of 5 years. This...
Pasha Entertainment is evaluating a new project that will have a life of 5 years. This project is estimated to generate sales of $250,000 each year. The annual costs are estimated to be $165,000. At Time 0, Pasha will need to invest $475,000 in new fixed assets. This will be depreciated on a straight-line method over the life of the project with no salvage value. Management has indicated that the sales and costs for this project are accurate within a...