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
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
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?
Problem Set 3
Year
0
1
2
3
Depriciation Rates
14.29%
24.49%
17.49%
Depriciation
$ 35,725.00 $ 61,225.00 $ 43,725.00 Book Value
$ 250,000.00 $ 214,275.00 $ 188,775.00 $ 206,275.00 Ending $ 250,000.00 $ 214,275.00 $ 153,050.00 $ 109,325.00 Sale
$ 5,000.00 Sale
$ 80,000.00 Book Value at Year 5
$ 55,775.00 Book Value at Year 5
$ 55,775.00 Profit
$ (50,775.00)
Profit
$ 24,225.00 Tax Rate @ 20%
$ (10,155.00)
Tax Rate @ 20%
$ 4,845.00 After Tax Sale Value
$ 15,155.00 After Tax Sale Value
$ 75,155.00 An equipment worth $250,000 is classified as a 7-year MACRS property. A
A) What is the book value of this asset at the end of yea
B) What is the depreciation expense in each of the year
C) If the equipment can be sold for $5,000 at then end of Year 5, what is th
D) If the equipment can be sold for $80,000 at then end of Year 5, what is t
The MACRS allowance percentages for the 7-year asset class are as follows, commencing with
8.93%, 8.92%, 8.93%, and 4.46%.
4
5
6
7
8
12.49%
8.93%
8.92%
8.93%
4.46%
$ 31,225.00 $ 22,325.00 $ 22,300.00 $ 22,325.00 $ 11,150.00 $ 218,775.00 $ 227,675.00 $ 227,700.00 $ 227,675.00 $ 238,850.00 $ 78,100.00 $ 55,775.00 $ 33,475.00 $ 11,150.00 $ - Assume a tax rate of 20%.
ars 1-8?
rs 1-8?
he after-tax salvage value?
the after-tax salvage value?
h year one: 14.29%, 24.49%, 17.49%, 12.49%,
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
Problem Set 4
Year
1
2
3
4
Depriciation Rates
20%
20%
20%
20%
Depriciation
$ 31,250.00 $ 31,250.00 $ 31,250.00 $ 31,250.00 Book Value
$ 250,000.00 $ 218,750.00 $ 187,500.00 $ 156,250.00 Ending $ 218,750.00 $ 187,500.00 $ 156,250.00 $ 125,000.00 Sale
$ 5,000.00 Sale
$ 80,000.00 Book Value at Year 5
$ 93,750.00 Book Value at Year 5
$ 93,750.00 Profit
$ (88,750.00)
Profit
$ (13,750.00)
Tax Rate @ 20%
$ (17,750.00)
Tax Rate @ 20%
$ (2,750.00)
After Tax Sale Value
$ 22,750.00 After Tax Sale Value
$ 82,750.00 A company purchased an equipment worth $250,000. It will be depreciated using the straight-li
rate of 20%.
A) What is the book value of this asset at the end of years
B) What is the depreciation expense in each of the years C) If the equipment can be sold for $5,000 at then end of Year 5, what is the
D) If the equipment can be sold for $80,000 at then end of Year 5, what is the
5
6
7
8
20%
20%
20%
20%
$ 31,250.00 $ 31,250.00 $ 31,250.00 $ 31,250.00 $ 125,000.00 $ 93,750.00 $ 62,500.00 $ 31,250.00 $ 93,750.00 $ 62,500.00 $ 31,250.00 $ - ine depreciation over 8 years. Assume a tax s 1-8?
1-8?
e after-tax salvage value?
e after-tax salvage value?
Problem S
Year
1
2
3
4
5
Depriciation Rates
20%
32%
19%
12%
6%
Depriciation
Book Value
Ending 1. Suppose that ABC Company purchased $10000 of machinery 3 years ago. The machinery is 5-year M
Value if the tax ra
2. Suppose that ABC Company purchased $10000 of machinery 4 years ago. The machinery is 5-year M
Value if the tax ra
3. Suppose that ABC Company purchased $10000 of machinery 5 years ago. The machinery is 5-year M
Value if the tax ra
The MACRS allowance percentages are as follows, commencing with
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
Set 5
MACRS property. The firm is selling this equipment today for $5000. What is the After-tax Salvage ate is 30%?
MACRS property. The firm is selling this equipment today for $5000. What is the After-tax Salvage ate is 30%?
MACRS property. The firm is selling this equipment today for $5000. What is the After-tax Salvage ate is 30%?
h year one: 20.00%, 32.00%, 19.20%, 11.52%, 11.52%, 5.76%.
Related Documents
Related Questions
Problem 4. Which project would you select on the basis of rate of return, assuming MARR =15%. Please use excel spreadsheet to answer.
arrow_forward
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
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
Coffer Company is analyzing two potential investments.
Project X
Cost of machine
Net cash flow:
Year 1
Year 2
$ 85,470
Project Y
$ 65,000
33,000
33,000
3,000
30,000
Year 3
Year 4
33,000
0
• 30,000
25,000
If the company is using the payback period méthod, 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.
arrow_forward
Do solve all 3 parts
arrow_forward
ff1
arrow_forward
Hi expart Provide solution
arrow_forward
Revenues generated by a new fad product are forecast as follows:
Year
Revenues
1
$50,000
2
40,000
3
20,000
4
10,000
Thereafter
0
Expenses are expected to be 50% of revenues, and working capital required in each year is expected to be 20% of revenues in the following year. The product requires an immediate investment of $40,000 in plant and equipment.
Required:
a. What is the initial investment in the product? Remember working capital.
b. If the plant and equipment are depreciated over 4 years to a salvage value of zero using straight-line depreciation, and the firm’s tax rate is 30%, what are the project cash flows in each year? Assume the plant and equipment are worthless at the end of 4 years.
c. If the opportunity cost of capital is 12%, what is the project's NPV?
d. What is project IRR?
arrow_forward
Revenues generated by a new fad product are forecast as follows: Year Revenues 1 $ 46,000 2 30,000 3 20,000 4 10,000 Thereafter 0 Expenses are expected to be 50% of revenues, and working capital required in each year is expected to be 30% of revenues in the following year. The product requires an immediate investment of $51,000 in plant and equipment. Required: What is the initial investment in the product? Remember working capital. If the plant and equipment are depreciated over 4 years to a salvage value of zero using straight-line depreciation, and the firm’s tax rate is 40%, what are the project cash flows in each year? If the opportunity cost of capital is 15%, what is project NPV? What is project IRR?
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
Can you help me work out question 1(a) please without having to use excel? Thank you in adv
arrow_forward
Given correct answer financial accounting question
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
- Problem 4. Which project would you select on the basis of rate of return, assuming MARR =15%. Please use excel spreadsheet to answer.arrow_forwardCoffer 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_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_forwardCoffer Company is analyzing two potential investments. Project X Cost of machine Net cash flow: Year 1 Year 2 $ 85,470 Project Y $ 65,000 33,000 33,000 3,000 30,000 Year 3 Year 4 33,000 0 • 30,000 25,000 If the company is using the payback period méthod, 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.arrow_forwardDo solve all 3 partsarrow_forward
- ff1arrow_forwardHi expart Provide solutionarrow_forwardRevenues generated by a new fad product are forecast as follows: Year Revenues 1 $50,000 2 40,000 3 20,000 4 10,000 Thereafter 0 Expenses are expected to be 50% of revenues, and working capital required in each year is expected to be 20% of revenues in the following year. The product requires an immediate investment of $40,000 in plant and equipment. Required: a. What is the initial investment in the product? Remember working capital. b. If the plant and equipment are depreciated over 4 years to a salvage value of zero using straight-line depreciation, and the firm’s tax rate is 30%, what are the project cash flows in each year? Assume the plant and equipment are worthless at the end of 4 years. c. If the opportunity cost of capital is 12%, what is the project's NPV? d. What is project IRR?arrow_forward
- Revenues generated by a new fad product are forecast as follows: Year Revenues 1 $ 46,000 2 30,000 3 20,000 4 10,000 Thereafter 0 Expenses are expected to be 50% of revenues, and working capital required in each year is expected to be 30% of revenues in the following year. The product requires an immediate investment of $51,000 in plant and equipment. Required: What is the initial investment in the product? Remember working capital. If the plant and equipment are depreciated over 4 years to a salvage value of zero using straight-line depreciation, and the firm’s tax rate is 40%, what are the project cash flows in each year? If the opportunity cost of capital is 15%, what is project NPV? What is project IRR?arrow_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_forwardCan you help me work out question 1(a) please without having to use excel? Thank you in advarrow_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