Book3
.xlsx
keyboard_arrow_up
School
University of Central Florida *
*We aren’t endorsed by this school
Course
5130
Subject
Finance
Date
Feb 20, 2024
Type
xlsx
Pages
10
Uploaded by GIRALDOD55
Problem Set 1
Initial outlay = Purchase Price + Shipping Cost + Initial investment
Purchase Price
$ 100,000.00 Shipping Cost
$ 5,000.00 Investment $ 4,000.00 Initial Outlay
$ 109,000.00 A company is considering purchasing a machine for $100,000. Shipping costs would be another $5,000. The project would require an initial investment in net working capital of $4,000 which would be recouped at the end of the project. What is the project's initial outlay?
Sales
$ 18,000,000.00 Operating Cost
$ 9,000,000.00 Depreciation
$ 4,000,000.00 Profit Before Tax
$ 5,000,000.00 Tax Expense
$ 2,000,000.00 Profit After Tax
$ 3,000,000.00 Depreciation
$ 4,000,000.00 Operating Cash Flow
$ 7,000,000.00 Annual Depreciation = Cost of Equipment/Useful Life Cost of Equipmet $ 250,000.00 Useful Life
10 years
Annual Depreciation
$ 25,000.00 Sales
$ 150,000.00 Variable Cost
$ 35,000.00 Fixed Cost
$ 40,000.00 Depreciation
$ 25,000.00 Net Operating Income
$ 50,000.00 Tax Expense @ 25%
$ 12,500.00 Net After Tax
$ 62,500.00 Depreciation
$ 25,000.00 Operating Cash Flow
$ 87,500.00 A)
A project will generate sales of $18 million. The operating costs (not including depreciation) are
The depreciation expense is $4 million. If the tax rate is 40%, what is the operating cash flo
B) A project will generate sales of $150,000. The variable costs are $35,000 and the fixed costs are $
project will use an equipment worth $250,000 that will be depreciated on a straight-line basis to a value over a 10-year life of the project.The interest expense is estimated to be $10,000. If the tax ra
what is the operating cash flow?
Problem Set 2
Sales
$ 250,000.00 Cash Expense
$ 80,000.00 Depreciation
$ 35,000.00 Net Operating Income
$ 135,000.00 Tax Expense @ 25%
$ 33,750.00 Net After Taxes
$ 101,250.00 Depreciation
$ 35,000.00 Operating Cash Flow
$ 136,250.00 Sales 140*100
$ 14,000.00 Variable Cost 35*100
$ 3,500.00 Fixes Cost
$ 10,000.00 Depreciation
$ 10,000.00 Net Operating Income
$ (9,500.00)
Tax Expense @ 25%
$ (2,375.00)
Net After Taxes
$ (7,125.00)
Depreciation
$ 10,000.00 Operating Cash Flow
$ 2,875.00 e $9 million. ow?
C) A project will generate sales of $250,000. The tot
worth $350,000 that will be depreciated on a straight-li
project will require an initial investment in net working
If the tax rate is 25%,
$40,000. The zero book rate is 25%, D)
A project will generate sales of 100 units annually and the fixed costs are $10,000. The project will use an
line basis to a zero book value over a 10-year life of th
tal cash expenses are $80,000. The project will use an equipment ine basis to a zero book value over a 10-year life of the project. The g capital is $5,000 which will be recouped at the end of the project. , what is the operating cash flow?
at a selling price of $140 each. The variable costs per unit are $35 n equipment worth $100,000 that will be depreciated on a straight-
he project. If the tax rate is 25%, what is the operating cash flow?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Coffer Company is analyzing two potential investments.
Cost of machine
Project X
$ 97,090
Net cash flow:
Year 1
Year 2
Year 3
Year 4
Project Y
$ 72,000
36,500
3,700
36,500
33,500
36,500
33,500
0
13,000
If the company is using the payback period method, and it requires a payback period of three years or less, which project(s) should
be selected?
Multiple Choice
○ Project Y.
○ Project X.
Both X and Y are acceptable projects.
Neither X nor Y is an acceptable project.
Project Y because it has a lower Initial Investment.
arrow_forward
4
You are considering the following investment activity. The facts are the following:
Required investment
300,000.00
Discount Rate
9%
Life of project
7.00
Years
Net income for the project
Sales
140,000.00
Expenses
Material
25,000.00
Labor
35,000.00
Overhead
15,000.00
Total Expenses
75,000.00
Net Income
65,000.00
What is the NPV of this investment?
What is the IRR of this investment?
Would you fund this project?
Show your work below
Year
0
1
2
3
4
5
6
7
arrow_forward
INFORMATION
The management of Mastiff Enterprises has a choice between two projects viz. Project Cos and Project Tan, each of
which requires an initial investment of R2 500 000. The following information is presented to you:
PROJECT TAN
5.1
5.2
5.3
Year
5.4
1
5.5
2
3
5
PROJECT COS
Net Profit
R
130 000
130 000
130 000
130 000
130 000
Net Profit
R
80 000
A scrap value of R100 000 is expected for Project Tan only. The required rate of return is 15%. Depreciation is calculated
using the straight-line method.
180 000
Use the information provided above to calculate the following. Where applicable, use the present value tables
provided in APPENDICES 1 and 2 that appear after QUESTION 5.
120 000
220 000
50 000
Payback Period of Project Tan (expressed in years, months and days).
Net Present Value of Project Tan.
Accounting Rate of Return on average investment of Project Tan (expressed to two decimal places).
Benefit Cost Ratio of Project Cos (expressed to three decimal places).
Internal Rate of…
arrow_forward
AL Rawabi SAOG a diary company based in al buraimi has four independent projects available.
Capital needed NPV
at time 0
RO.
RO.
Project 1
10,000
30,000
Project 2
8,000
25,000
Project 3
12,000
30,000
Project 4
16,000
36,000
If the company has RO.32,000(Capital Budget) to invest at time 0, and each project is Indivisible, but none
can be delayed, what is the maximum NPV that can be earned?
Note: Use PI Method for Ranking the project
a. OR.85,000
b. OR.89,500
c. OR.103,000
d. OR.102,250
arrow_forward
Can I please have the answers in these format : payback period = investement
net annual inflow
ARR = Average annual profit x 100
Average investment 1
can I have the answers in these type of format
arrow_forward
Subject: Engineering Economy
arrow_forward
Do solve all 3 parts
arrow_forward
ff1
arrow_forward
Q1: For the machines indicated below. Consider i= 10% per year
First cost
Annual cost
Salvage value
Life duration
Machine A
20,000 $
5,000 $
7,500 $
3
Machine B
25,000
4,000
6,000
4
A- Draw cash flow diagram for each machine for one cycle of each project
B- Draw cash flow diagram for each project considering the LCM life cycle (Hint:
different project duration, need to have the LCM life cycle)
C- Compare the machines to select best alternative one based on Present worth analysis
method
D- Repeat part B considering Future worth analysis
arrow_forward
Walden Industries is considering investing in
production-management
software that costs
$600,000,
has
$67,000
residual value, and leads to cost savings of
$2,300,000
per year over its
five-year
life. Calculate the average amount invested in the asset that should be used for
calculating the accounting rate of return.
Question content area bottom
Part 1
A.
$333,500
В.
$667,000
С.
$67,000
D. $600,000
arrow_forward
NPV and EVA A project costs $2,500,000 up front and will generate cash flows in perpetuity of $240,000. The firm’s cost of capital is 9%.
a. Calculate the project’s NPV.
b. Calculate the annual EVA in a typical year.
c. Calculate the overall project EVA and compare to your answer in part a
arrow_forward
i need the answer quickly
arrow_forward
Consider the following information about a project:
PROJECT
YEAR O
YEAR 1
YEAR 2
YEAR 3 YEAR 4
COSTS
$160,000
$43,000
$50,000
$50,000
$64,000
BENEFITS
$0
$400,000
$400, 000 $500,000 $500,000
a) Calculate the NPV assuming 10% discount rate
b) Determine in which year will be the payback
c) Calculate (ROI)?
Provide the detail answer for your calculation.
arrow_forward
Initial cost:
$467,000
Cash flow year one:
$134,000
Cash flow year two:
$230,000
Cash flow year three:
$187,000
Cash flow year four:
$134,000
a. Using a discount rate of
10%
for this project and the NPV model, determine whether the company should accept or reject this project.
b. Should the company accept or reject it using a discount rate of
14%?
arrow_forward
QUESTION 1
Agro Tech Corporation is considering investing in a new IT system for selling to its clients. The company has
identified two new possible systems, which would be suitable for its customers. Only one of the systems can be
selected and the directors are looking for guidance on which system would be the best. The company requires a
15% rate of return on projects of this nature.
The installation cost per project will be R100 000 each, while systems can be disposed for R200 000 each after
five- years life span.
Cash flows for Agro Tech Corporation: IT System (Rands)
PERIOD
1
2
3
4
5
SYSTEM A -4 000 000
R1 800 000 R1 700 000 R1 600 000 R1 500 000 R1 400 000
SYSTEM B -3 500 000
1 500 000 1 500 000
1 500 000
1 400 000 R1 300 000
Required:
1.1 Determine the payback period in years, months and days for both systems
1.2 Based on your calculations in 1.1, which system should Agro Tech Corporation consider? Why?
1.3 Calculate the Net Present Value for both systems.
1.4 Calculate the…
arrow_forward
1.
arrow_forward
Solve Problem 20.19 using Excel.
arrow_forward
Apo
Don't upload any image please
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Related Questions
- Coffer Company is analyzing two potential investments. Cost of machine Project X $ 97,090 Net cash flow: Year 1 Year 2 Year 3 Year 4 Project Y $ 72,000 36,500 3,700 36,500 33,500 36,500 33,500 0 13,000 If the company is using the payback period method, and it requires a payback period of three years or less, which project(s) should be selected? Multiple Choice ○ Project Y. ○ Project X. Both X and Y are acceptable projects. Neither X nor Y is an acceptable project. Project Y because it has a lower Initial Investment.arrow_forward4 You are considering the following investment activity. The facts are the following: Required investment 300,000.00 Discount Rate 9% Life of project 7.00 Years Net income for the project Sales 140,000.00 Expenses Material 25,000.00 Labor 35,000.00 Overhead 15,000.00 Total Expenses 75,000.00 Net Income 65,000.00 What is the NPV of this investment? What is the IRR of this investment? Would you fund this project? Show your work below Year 0 1 2 3 4 5 6 7arrow_forwardINFORMATION The management of Mastiff Enterprises has a choice between two projects viz. Project Cos and Project Tan, each of which requires an initial investment of R2 500 000. The following information is presented to you: PROJECT TAN 5.1 5.2 5.3 Year 5.4 1 5.5 2 3 5 PROJECT COS Net Profit R 130 000 130 000 130 000 130 000 130 000 Net Profit R 80 000 A scrap value of R100 000 is expected for Project Tan only. The required rate of return is 15%. Depreciation is calculated using the straight-line method. 180 000 Use the information provided above to calculate the following. Where applicable, use the present value tables provided in APPENDICES 1 and 2 that appear after QUESTION 5. 120 000 220 000 50 000 Payback Period of Project Tan (expressed in years, months and days). Net Present Value of Project Tan. Accounting Rate of Return on average investment of Project Tan (expressed to two decimal places). Benefit Cost Ratio of Project Cos (expressed to three decimal places). Internal Rate of…arrow_forward
- AL Rawabi SAOG a diary company based in al buraimi has four independent projects available. Capital needed NPV at time 0 RO. RO. Project 1 10,000 30,000 Project 2 8,000 25,000 Project 3 12,000 30,000 Project 4 16,000 36,000 If the company has RO.32,000(Capital Budget) to invest at time 0, and each project is Indivisible, but none can be delayed, what is the maximum NPV that can be earned? Note: Use PI Method for Ranking the project a. OR.85,000 b. OR.89,500 c. OR.103,000 d. OR.102,250arrow_forwardCan I please have the answers in these format : payback period = investement net annual inflow ARR = Average annual profit x 100 Average investment 1 can I have the answers in these type of formatarrow_forwardSubject: Engineering Economyarrow_forward
- Do solve all 3 partsarrow_forwardff1arrow_forwardQ1: For the machines indicated below. Consider i= 10% per year First cost Annual cost Salvage value Life duration Machine A 20,000 $ 5,000 $ 7,500 $ 3 Machine B 25,000 4,000 6,000 4 A- Draw cash flow diagram for each machine for one cycle of each project B- Draw cash flow diagram for each project considering the LCM life cycle (Hint: different project duration, need to have the LCM life cycle) C- Compare the machines to select best alternative one based on Present worth analysis method D- Repeat part B considering Future worth analysisarrow_forward
- Walden Industries is considering investing in production-management software that costs $600,000, has $67,000 residual value, and leads to cost savings of $2,300,000 per year over its five-year life. Calculate the average amount invested in the asset that should be used for calculating the accounting rate of return. Question content area bottom Part 1 A. $333,500 В. $667,000 С. $67,000 D. $600,000arrow_forwardNPV and EVA A project costs $2,500,000 up front and will generate cash flows in perpetuity of $240,000. The firm’s cost of capital is 9%. a. Calculate the project’s NPV. b. Calculate the annual EVA in a typical year. c. Calculate the overall project EVA and compare to your answer in part aarrow_forwardi need the answer quicklyarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT