Homework 1 (Empty)
xlsx
keyboard_arrow_up
School
Temple University *
*We aren’t endorsed by this school
Course
BA3512
Subject
Finance
Date
Apr 3, 2024
Type
xlsx
Pages
30
Uploaded by ChiefDiscovery9104
Retirement Problem
Interest
7%
Annual Deposit
1601.17
Annual Withdrawl
$10,000
Age
Beginning of Year
End of Year
40
1
0
41
2
1
42
3
2
43
4
3
44
5
4
45
6
5
46
7
6
47
8
7
48
9
8
49
10
9
50
11
10
51
12
11
52
13
12
53
14
13
54
15
14
55
16
15
56
17
16
57
18
17
58
19
18
59
20
19
60
21
20
61
22
21
62
23
22
63
24
23
64
25
24
65
26
25
66
27
26
67
28
27
68
29
28
69
30
29
Instead of using Solver, use PV and PMT to solve for annual de
annual withdraw
10000
Interest rate
7%
Number of Yrs. 10
The key is that the future value of first 20 years' deposits (ann
First solve for present value of all the withdrawals using PV fun
PV
70235.82
Then use PMT to solve for the annual deposit
Number of Yrs. 20
PMT
1601.17
=
Account Balance (Beginning)
Deposit (Beginning)
Interest Earned for the year
Withdraw (End)
0.00
1,601.17
112.08
0.00
1,713.26
1,601.17
232.01
0.00
3,546.44
1,601.17
360.33
0.00
5,507.95
1,601.17
497.64
0.00
7,606.76
1,601.17
644.56
0.00
9,852.49
1,601.17
801.76
0.00
12,255.43
1,601.17
969.96
0.00
14,826.56
1,601.17
1,149.94
0.00
17,577.68
1,601.17
1,342.52
0.00
20,521.37
1,601.17
1,548.58
0.00
23,671.13
1,601.17
1,769.06
0.00
27,041.36
1,601.17
2,004.98
0.00
30,647.51
1,601.17
2,257.41
0.00
34,506.10
1,601.17
2,527.51
0.00
38,634.78
1,601.17
2,816.52
0.00
43,052.47
1,601.17
3,125.76
0.00
47,779.40
1,601.17
3,456.64
0.00
52,837.22
1,601.17
3,810.69
0.00
58,249.08
1,601.17
4,189.52
0.00
64,039.77
1,601.17
4,594.87
0.00
70,235.82
0.00
4,916.51
10,000.00
65,152.32
0.00
4,560.66
10,000.00
59,712.99
0.00
4,179.91
10,000.00
53,892.89
0.00
3,772.50
10,000.00
47,665.40
0.00
3,336.58
10,000.00
41,001.97
0.00
2,870.14
10,000.00
33,872.11
0.00
2,371.05
10,000.00
26,243.16
0.00
1,837.02
10,000.00
18,080.18
0.00
1,265.61
10,000.00
9,345.79
0.00
654.21
10,000.00
eposit:
nuity due) at the end of year 20 is the same as the present value of the 10 years' withdraw (ordinary annuity)
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
nction
Account Total (End)
1,713.26
3,546.44
5,507.95
7,606.76
9,852.49
12,255.43
14,826.56
17,577.68
20,521.37
23,671.13
27,041.36
30,647.51
34,506.10
38,634.78
43,052.47
47,779.40
52,837.22
58,249.08
64,039.77
70,235.82
65,152.32
59,712.99
Parameters: 53,892.89
47,665.40
Set the last cell in the row of "Accou
41,001.97
33,872.11
26,243.16
18,080.18
9,345.79
0.00
) at the end of year 20
Quesiton 1
. You are currently 40 years old and intend to retire at
easier, you intend to start a retirement account. At the beginning
some money to your retirement account till your retire. You expe
year. After retirement at age 60, you want to withdraw $10,000 f
the end
of each year for 10 years. How much money should you each year? Requirement: Use all the three methods (1) Solver, (2) Goal Seek
solve for annual deposit. Use snipping tool to screenshot the dial
Seek with the appropriate parameters.
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
unt Total (End)" to the Value of "0" by changing the "Annual deposits". t age 60. To make your retirement g of each of years, you will deposit ect the account will earn 7% per from your retirement account at plan to deposit in your retirement k, and (3) PV and PMT function to log windows of Solver and Goal
94500
Retirement Problem
Interest
7%
Annual Deposit
1713.26
Annual Withdrawl
$10,000
Age
Beginning of Year
End of Year
Account Balance (Beginning)
40
1
0
0.00
41
2
1
1,713.26
42
3
2
3,546.44
43
4
3
5,507.95
44
5
4
7,606.76
45
6
5
9,852.49
46
7
6
12,255.43
47
8
7
14,826.56
48
9
8
17,577.68
49
10
9
20,521.37
50
11
10
23,671.13
51
12
11
27,041.36
52
13
12
30,647.51
53
14
13
34,506.10
54
15
14
38,634.78
55
16
15
43,052.47
56
17
16
47,779.40
57
18
17
52,837.22
58
19
18
58,249.08
59
20
19
64,039.77
60
21
20
70,235.82
61
22
21
65,152.32
62
23
22
59,712.99
63
24
23
53,892.89
64
25
24
47,665.40
65
26
25
41,001.97
66
27
26
33,872.11
67
28
27
26,243.16
68
29
28
18,080.18
69
30
29
9,345.79
Instead of using Solver, use PV and PMT to solve for annual deposit:
annual withdraw
10000
Interest rate
7%
Number of Yrs.
10
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
The key is that the future value of first 20 years' deposits (annuity due) at the end of year 20
First solve for present value of all the withdrawals using PV function
PV
70235.82
Then use PMT to solve for the annual deposit
Number of Yrs. 20
PMT
1713.26
Deposit or Withdraw (Beginning)
Interest Earned for the year
Deposite or Withdraw (End)
0.00
0.00
1,713.26
0.00
119.93
1,713.26
0.00
248.25
1,713.26
0.00
385.56
1,713.26
0.00
532.47
1,713.26
0.00
689.67
1,713.26
0.00
857.88
1,713.26
0.00
1,037.86
1,713.26
0.00
1,230.44
1,713.26
0.00
1,436.50
1,713.26
0.00
1,656.98
1,713.26
0.00
1,892.90
1,713.26
0.00
2,145.33
1,713.26
0.00
2,415.43
1,713.26
0.00
2,704.43
1,713.26
0.00
3,013.67
1,713.26
0.00
3,344.56
1,713.26
0.00
3,698.61
1,713.26
0.00
4,077.44
1,713.26
0.00
4,482.78
1,713.26
0.00
4,916.51
-10,000.00
0.00
4,560.66
-10,000.00
0.00
4,179.91
-10,000.00
0.00
3,772.50
-10,000.00
0.00
3,336.58
-10,000.00
0.00
2,870.14
-10,000.00
0.00
2,371.05
-10,000.00
0.00
1,837.02
-10,000.00
0.00
1,265.61
-10,000.00
0.00
654.21
-10,000.00
0 is the same as the present value of the 10 years' withdraw (ordinary annuity) at the end of year 20
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
Account Total (End)
1,713.26
3,546.44
5,507.95
7,606.76
9,852.49
12,255.43
14,826.56
17,577.68
20,521.37
23,671.13
27,041.36
30,647.51
34,506.10
38,634.78
43,052.47
47,779.40
52,837.22
58,249.08
64,039.77
70,235.82
65,152.32
59,712.99
53,892.89
47,665.40
41,001.97
33,872.11
26,243.16
18,080.18
9,345.79
0.00
Parameters
Set the last cell in the row o
Question 2: You are currently 40 years old an
start a retirement account. At the END
of ea
your retire. You expect the account will earn
from your retirement account at the
END
of e
Requirement: Use all the three methods (1
deposit. Use snipping tool to screenshot the
of "Account Total (End)" to the Value of "0" by changing the "Annual deposits". nd intend to retire at age 60. To make your retirement easier, you intend to ach of years, you will deposit some money to your retirement account till n 7% per year. After retirement at age 60, you want to withdraw $10,000 each year for 10 years. How much money should you plan to deposit in your retirement each year? 1) Solver, (2) Goal Seek, and (3) PV and PMT function to solve for annual dialog windows of Solver and Goal Seek with the appropriate parameters.
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
94500
QX CORP. - CAPITAL PROJECT ANALYSIS
Cost of machine
$ 54,500,000 Tax Rate
25%
Required Rate of Return
14%
Material Cost per Brake Pad
$ 30.00 Labor Cost per Brake Pad
$ 20.00 Year
0
1
# of Brake Pads Sold
100,000 Sale Price per Brake Pad
$ 200.00 Sales
$ 20,000,000 Material Cost per Brake Pad
$ 30.00 Labor Cost per Brake Pad
$ 20.00 COGS - Material and Labor
5,000,000 COGS as a % of Revenue
25.0%
Operating Expenses
500,000 Operating Expenses as a % of COGS
10.0%
Depreciation Expense
10,900,000 ACCEPT OR REJECT THE PROJECT AND WHY?
(Your answer here) Yes, you would accept this project because the IRR of 19.63% is higher than the Required Rate of Return of 14%.
Depreciation MACRS % 20.00%
EBIT
3,600,000 Taxes
900,000 Net Income
2,700,000 Add: Depreciation
10,900,000 Deduct: Change in net working capital
(You can ignore this raw) Add: After-tax scrap/residual value
54,500,000.0 Cash Flow
-54,500,000 $ 13,600,000 Net Present Value
$9,395,912.61 Internal Rate of Return
19.36%
$9,395,913 Required rate
10%
of return
12%
14%
15%
17%
19%
$9,395,913 10%
12%
14%
15%
17%
19%
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
FINAL 5.2.2019
2
3
4
5
6
110,000 120,000 125,000 110,000 100,000 $ 200.00 $ 200.00 $ 200.00 $ 200.00 $ 200.00 $ 22,000,000 $ 24,000,000 $ 25,000,000 $ 22,000,000 $ 20,000,000 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 20.00 $ 20.00 $ 20.00 $ 20.00 $ 20.00 5,500,000 6,000,000 6,250,000 5,500,000 5,000,000 25.0%
25.0%
25.0%
25.0%
25.0%
550,000 600,000 625,000 550,000 500,000 10.0%
10.0%
10.0%
10.0%
10.0%
17,440,000 10,464,000 6,278,400 6,278,400 3,139,200 QX Corp. is a manufacturer of automotive brake pads for original equipment manufacturers (OEM
for the Model 3. TESLA is currently not a customer and their brake pad is unique and requires a sp
require the purchase of the specialized machine that will be needed to manufacture the brake pad
analyst in the Financial Planning & Analysis Department. The production department supplied yo
--Cost of the machine: $54,500,000
--QX will sell the following number of brake pads per year.
Year 1 - 100,000 , Year 2 - 110,000, Year 3 - 120,000, Year 4 - 125,000, Year 5 - 110,000, Year 6 - -- Sales price per pad is $200.00
-- The material cost per brake pad to manufactue is expected to be $30 per pad for all eight years
-- The labor cost per brake pad is expected to be $20 per pad for all eight years
-- Operating expenses (not including depreciation) will be 10.0% of COGS
-- The equipment will be depreciated based on the following MCARS tax rates which are:
Year 1 - 20.0%, Year 2 - 32.0%, Year 3 - 19.2%, Year 4 - 11.52%, Year 5 - 11.52% and Year 6 - 5.76
-- The equipment will be sold for $1,000,000 at the end of year 8. -- Tax Rate is 25%
-- Management requires a rate of return on this project of 14%
REQUIRED
You are to prepare an IRR and NPV analysis and recommend whether to ACCEPT or REJECT the p
following sensitivities for NPV calculation.
Tax rate - 20%, 22%, 24%, 25%, 27%, 29%
Required rate of return - 10%, 12%, 14%, 15%, 17%, 19%
32.00%
19.20%
11.52%
11.52%
5.76%
(1,490,000) 6,936,000 11,846,600 9,671,600 11,360,800 (372,500) 1,734,000 2,961,650 2,417,900 2,840,200 (1,117,500) 5,202,000 8,884,950 7,253,700 8,520,600 17,440,000 10,464,000 6,278,400 6,278,400 3,139,200 $ 16,322,500 $ 15,666,000 $ 15,163,350 $ 13,532,100 $ 11,659,800 CREATE DATA TABLE BELOW
Tax rate
20%
22%
24%
25%
27%
20%
22%
24%
25%
27%
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
7
8
100,000 90,000 $ 200.00 $ 200.00 $ 20,000,000 $ 18,000,000 $ 30.00 $ 30.00 $ 20.00 $ 20.00 5,000,000 4,500,000 25.0%
25.0%
500,000 450,000 10.0%
10.0%
Ms). TESLA has approached them to manufacture brake pads pecialized machine. The contract will be for 8 years and will d as well as hiring additional employees. You are a financial ou with the following:
100,000, Year 7 - 100,000, Year 8 - 90,000
6%
project and WHY. Also prepare a DATA TABLE assuming the
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
14,500,000 13,050,000 3,625,000 3,262,500 10,875,000 9,787,500 - - 750,000
$ 10,875,000 $ 9,037,500 29%
29%
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
94500
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
CHEMX, INC. - CAPITAL PROJECT ANALYSIS
$ in millions
Cost of machine
$ 2,600,000 Residual value end of year 10
3.0%
Expected COGS Savings
10.0%
Annual incremental working capital
$ 2,000 Tax depreciation 5 year MACRS based on cost of the machine
Year 1
20%
Year 2
32%
Year 3
19%
Year 4
12%
Year 5
12%
Year 6
5%
Tax Rate
25%
Required Rate of Return
10%
PERIOD
0
1
2
Cost of goods sold - Harrisburg, PA plant
$ 6,850,000 $ 7,050,000 Cost savings (=revenue)
$ 685,000 $ 705,000 Less: Depreciation
520,000 832,000 EBIT
165,000
-127,000
Less: Taxes
41,250
-31,750
Net Income
123,750
-95,250
Add: Depreciation
520,000 832,000 Less: Change in net working capital
2,000 2,000 2,000 Add: After-tax scrap/residual value
2,600,000
Cash Flow
-2,602,000
641,750
734,750
Cumulative Cash Flow
$ 641,750 $ 1,376,500 Payback Period
Payback----->
CF in year 4 not
Percentage not
Percentage nee
plus first X year
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
NPV
$ 845,143 IRR
18.7%
PAYBACK PERIOD
3.883
Profitability Index
1.32
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
3
4
5
6
7
8
$ 7,250,000 $ 7,450,000 $ 7,650,000 $ 7,850,000 $ 8,050,000 $ 8,250,000 $ 725,000 $ 745,000 $ 765,000 $ 785,000 $ 805,000 $ 825,000 494,000 312,000 312,000 130,000 231,000
433,000
453,000
655,000
805,000
825,000
57,750
108,250
113,250
163,750
201,250
206,250
173,250
324,750
339,750
491,250
603,750
618,750
494,000 312,000 312,000 130,000 2,000 2,000 2,000 2,000 2,000 (58,500)
665,250
634,750
649,750
619,250
601,750
560,250
$ 2,041,750 $ 2,676,500 $ 3,326,250 $ 3,945,500 $ 4,547,250 $ 5,107,500 -2,602,000
t needed
$ 74,500 t needed
11.7%
eded
88.3%
rs
ChemX, Inc. is a manufacturer of chemical products with locations in the Un
States. Its manufacturing plant in Harrisburg, PA is considering the purchase
new mixing machine. The cost of goods sold will be $6,850,000 in year 1, an
increase by $200,000 each year
. The cost of the machine is $2,600,000 and it is expected to result in cost sav
10.0% of that location's cost of goods sold over the life of the mixing machin
which is 8 years. Over the 8 years an annual investment in working capital will be required of
(needs to be input at the beginning of year). At the end of its life it can be so
3% of the original cost. Five year MACRS depreciation will be used for tax purposes, which has the depreciation rate of 20%, 32%, 19%, 12%, 12% and
the first five years. The company's marginal tax rate is 25%.
Prepare an analysis to determine if this project will generate an attractive le
economic benefits. Specifically determine the net present value and interna
of return, payback period, discounted payback period, profitability index of project.
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
nited e of a nd will vings of ne f $2,000 old for d 5% for evel of al rate the ACCEPT OR REJECT THE PROJECT AND WHY?
(Your answer here) Yes, you accept this project because this IRR of 19.1% is higher the Required Rate of Return of 10% and NPV is greater than 0.
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
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
94500
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 Documents
Related Questions
The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion and upgrade to
computer servers. The projects have different useful lives, but each requires an investment of $490,000. The
estimated net cash flows from each project are as follows:
Year
1
2
Year
3
4
5
The committee has selected a rate of 12% for purposes of net present value analysis. It also estimates that the
residual value at the end of each project's useful life is $0, but at the end of the fourth year, the office expansion's
residual value would be $180,000.
6
7
8
9
10
1
1
2
3
2
4
5
6
3
0.943
0.890
0.840
Present Value of $1 at Compound Interest
6%
10%
12%
0.792
0.747
0.705
0.665
0.627
0.592
0.558
Net Cash
Flows
Office
Expansion
$125,000
125,000
125,000
125,000
125,000
125,000
0.943
1.833
2.673
0.909
0.826
0.751
0.683
0.621
0.564
0.513
0.467
0.424
0.386
Net Cash
Flows
Servers
$165,000
165,000
165,000
165,000
0.909
1.736
2.487
0.893
0.797
0.712
0.636
0.567
0.507
0.452
0.404
0.361
0.322…
arrow_forward
The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion and upgrade to
computer servers. The projects have different useful lives, but each requires an investment of $490,000. The
estimated net cash flows from each project are as follows:
Year
1
1
2
3
4
2
Year
5
6
3
7
8
9
10
4
The committee has selected a rate of 12% for purposes of net present value analysis. It also estimates that the
residual value at the end of each project's useful life is $0, but at the end of the fourth year, the office expansion's
residual value would be $180,000.
5
6
0.943
0.890
0.840
Present Value of $1 at Compound Interest
6%
10%
0.792
0.747
0.705
0.665
0.627
Net Cash
Flows
Office
Expansion
$125,000
125,000
125,000
125,000
125,000
125,000
0.592
0.558
0.909
0.826
0.751
0.683
0.621
0.564
0.513
Net Cash
Flows
Servers
0.467
$165,000
165,000
165,000
165,000
0.424
0.386
12%
0.893
0.797
0.712
0.636
0.567
0.507
0.452
0.404
0.361
0.322
15%
0.870
0.756
0.658
0.572
0.497
0.432…
arrow_forward
Net present value-unequal lives
Project 1 requires an original investment of $50,100. The project will yield cash flows of $10,000 per year for 8 years. Project 2 has a computed net present
value of $11,600 over a 6-year life. Project 1 could be sold at the end of 6 years for a price of $38,000.
Use the Present Value of $1 at Compound Interest and the Present Value of an Annuity of $1 at Compound Interest tables shown below.
Present Value of $1 at Compound Interest
6%
10%
Year
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
0.943
0.890
0.840
0.792
0.747
7
0.705
0.665
0.627
0.592
0.558
0.943
1.833
2.673
3.465
4.212
4.917
0.909
5.582
0.826
0.751
0.683
0.621
0.564
0.513
0.467
0.424
0.386
0.909
1.736
2.487
3.170
3.791
4.355
12%
4.868
0.893
0.797
0.712
0.636
0.567
0.507
0.452
0.404
0.361
0.322
Present Value of an Annuity of $1 at Compound Interest
Year
6%
10%
12%
15%
20%
0.893
1.690
2.402
3.037
3.605
4.111
15%
4.564
0.870
0.756
0.658
0.572
0.497
0.432
0.376
0.327
0.284
0.247
0.870
1.626
2.283
2.855
3.353…
arrow_forward
Franklin's new snowmobile cost $9,500. After his down payment of $1,500, he financed the
remainder at 10% for 3 years. Use the table to find the monthly payment for the amortized loan.
Find the total interest paid on the loan.
Click the icon to view a table of monthly payments on a $1,000 loan.
The monthly payments for this loan are $.
(Round to the nearest cent as needed.)
Enter your answer in the answer box and then click Check Answer.
?
1 part
remaining
Clear All
Greck Answer
javascript:doExercise(5);
Copyright © 2020 Pearson Education Inc. All rights reserved. |
99
a
近
arrow_forward
Winett Corporation is considering an investment in special-purpose equipment to enable the company to obtain a
four-year municipal contract. The equipment costs $222,000 and would have no salvage value when the contract
expires at the end of four years. Estimated annual operating results of the project are as follows.
Revenue from contract sales.
Expenses other than depreciation
Depreciation (straight-line basis)
Increase in net income from contract work
$211,000
55,500
All revenue and all expenses other than depreciation will be received or paid in cash in the same period as
recognized for accounting purposes. Compute the following for Winett's proposal to undertake this contract.
a. Payback period
b.
C.
a. Payback period.
b. Return on average investment. (Round your percentage answer to 1 decimal place (i.e., 0.123 to be entered as
12.3).)
c. Net present value of the proposal to undertake contract work, discounted at an annual rate of 10 percent. (Refer
to the annuity table in…
arrow_forward
Present value of an ordinary annuity. Fill in the missing present values in the following table for an ordinary annuity:
arrow_forward
In order to buy a vacation home, Neal and Lilly took out a 20-year mortgage for $220,000 at
an annual interest rate of 6%. After 10 years, they refinanced the unpaid balance of
$142,125 at an annual rate of 4%. Use the table to find the monthly payments on the original
loan; the monthly payments on the new loan; and the total amount saved on interest by
refinancing.
Click the icon to view a table of monthly payments on a $1,000 loan.
The monthly payments on the original loan are $
(Type an integer or a decimal.)
Enter your answer in the answer box and then click Check Answer.
2 parts
remaining
Clear All
Check Answrer
javascript:doExercise(6);
10:45 PM
10/26/2020
120
arrow_forward
Number of Years for the Loan
Annual Interest
3
10
20
30
Rate
4%
$29.53
$22.58
$10.12
$6.06
$4.77
5%
29.97
23.03
10.61
6.60
5.37
6%
30.42
23.49
11.10
7.16
6.00
8%
31.34
24.41
12.13
8.36
7.34
10%
32.27
25.36
13.22
9.65
8.78
12%
33.21
26.33
14.35
11.01
10.29
A borrower took out a mortgage loan for 20 years in the amount of $95,000 with an annual interest rate of 12%.
a. Use the table of monthly payments on $1,000 loan, to find the monthly payment for this mortgage. $
b. Find the total interest paid on the loan. $
arrow_forward
Grove Media plans to acquire production equipment for $845,000 that will be depreciated for tax purposes as follows: year 1,
$329,000; year 2, $189,000; and in each of years 3 through 5, $109,000 per year. A 10 percent discount rate is appropriate for this
asset, and the company's tax rate is 20 percent. Use Exhibit A.8 and Exhibit A.9.
Required:
a. Compute the present value of the tax shield resulting from depreciation.
b. Compute the present value of the tax shield from depreciation assuming straight-line depreciation ($169,000 per year).
Complete this question by entering your answers in the tabs below.
Required A Required B
Compute the present value of the tax shield resulting from depreciation.
Note: Round PV factor to 3 decimal places.
Present value of the tax shield
arrow_forward
Increasing the down payment on a mortgage reduces both the size of the monthly payments and
the total interest paid. Calculate (a) the reduction in the monthly payment by increasing the down
payment by the amount specified, and (b) the amount saved on interest over the life of the loan.
Assume the mortgage is for 10 years and use the amortization table to find the monthly payments.
Increase in
Amount of Loan Interest Rate
Down Payment Down payment
$191,000
12%
$32,000
$15,000
Click the icon to view a table of monthly payments on a $1,000 loan.
a. The monthly payment will be reduced by $ when the down payment is increased by $15,000.
(Round to the nearest cent as needed.)
Enter your answer in the answer box and then click Check Answer.
1 part
Check Answer
SO
Clear All
remaining
javascript:doExercise(5);
Copyright © 2020 Pearson Education Inc. All rights reserved. Ter
99+
a
近
arrow_forward
None
arrow_forward
naru
arrow_forward
11
arrow_forward
QUESTION 5
Katharine Bartle will receive an annuity of $4,090.00 every month for 23 years. How much is this cash flow worth to them today if the
payments begin today? Assume a discount rate of 5.00%.
Oa. $55,398.13
b. $2,119,880.47
c. $672,837.73
Od. $170,156.69
arrow_forward
Net Present Value Method for a Service Company
Opulence Corporation has recently placed into service some of the largest cruise ships in the world. One
of these ships, the Bellwether, can hold up to 3,200 passengers and it can cost $640 million to build.
Assume the following additional information:
There will be 300 cruise days per year operated at a full capacity of 3,200 passengers.
• The variable expenses per passenger are estimated to be $95 per cruise day.
The revenue per passenger is expected to be $475 per cruise day.
The fixed expenses for running the ship, other than depreciation, are estimated to be $94,848,000
per year.
• The ship has a service life of 10 years, with a residual value of $100,000,000 at the end of 10 years.
Present Value of $1 at Compound Interest
Year
6%
10%
12%
15%
20%
1
0.943
0.909
0.893
0.870
0.833
2
0.890
0.826
0.797
0.756
0.694
0.840
0.751
0.712
0.658
0.579
4
0.792
0.683
0.636
0.572
0.482
0.747
0.621
0.567
0.497
0.402
6
0.705
0.564
0.507
0.432
0.335
7…
arrow_forward
PART 2 Financial Tools
P5-19 Future value of an annuity For each case in the accompanying table, answer the
questions that follow.
Case
B
E
meny
Amount of annuity
$ 2,500
30.000
11,500
6,000
Interest rate
*%*
23^2
12
14
Deposit period (years
a. Calculate the future value of the annuity assuming that it is
(1) An ordinary annuity,
(2) An annuity due.
b. Compare your findings in parts all) and a(2). All else being identical, which type
of annuity-- ordinary or annuity due—is preferable? Explain why,
arrow_forward
Determine the monthly principal and interest payment for a 20-year mortgage when the amount
financed is $285,000 and the annual percentage rate (APR) is 4.0%.
The monthly principal and interest payment is
(Round to the nearest cent as needed.).
arrow_forward
Crab Company is considering a project with an initial investment of $600,000 that is expected to produce cash inflows of $129,500 for ten years. Crab's required rate of return is 16%.
(Click on the icon to view Present Value of $1 table.)
E (Click on the icon to view Present Value of Ordinary Annuity of $1 table.)
14.
What is the NPV of the project?
15.
What is the IRR of the project?
16.
Is this an acceptable project for Crab?
14. What is the NPV of the project? (Enter the factor amount to three decimal places, X.XXX. Round the present value of the annuity to the nearest whole dollar. Use parentheses or a minus sign for a negative net present value.)
Net Cash
Annuity PV Factor
Present
(i-16%, n=10)
Value
Years
Inflow
1- 10
Present value of annuity
Investment
Net present value
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Related Questions
- The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion and upgrade to computer servers. The projects have different useful lives, but each requires an investment of $490,000. The estimated net cash flows from each project are as follows: Year 1 2 Year 3 4 5 The committee has selected a rate of 12% for purposes of net present value analysis. It also estimates that the residual value at the end of each project's useful life is $0, but at the end of the fourth year, the office expansion's residual value would be $180,000. 6 7 8 9 10 1 1 2 3 2 4 5 6 3 0.943 0.890 0.840 Present Value of $1 at Compound Interest 6% 10% 12% 0.792 0.747 0.705 0.665 0.627 0.592 0.558 Net Cash Flows Office Expansion $125,000 125,000 125,000 125,000 125,000 125,000 0.943 1.833 2.673 0.909 0.826 0.751 0.683 0.621 0.564 0.513 0.467 0.424 0.386 Net Cash Flows Servers $165,000 165,000 165,000 165,000 0.909 1.736 2.487 0.893 0.797 0.712 0.636 0.567 0.507 0.452 0.404 0.361 0.322…arrow_forwardThe investment committee of Sentry Insurance Co. is evaluating two projects, office expansion and upgrade to computer servers. The projects have different useful lives, but each requires an investment of $490,000. The estimated net cash flows from each project are as follows: Year 1 1 2 3 4 2 Year 5 6 3 7 8 9 10 4 The committee has selected a rate of 12% for purposes of net present value analysis. It also estimates that the residual value at the end of each project's useful life is $0, but at the end of the fourth year, the office expansion's residual value would be $180,000. 5 6 0.943 0.890 0.840 Present Value of $1 at Compound Interest 6% 10% 0.792 0.747 0.705 0.665 0.627 Net Cash Flows Office Expansion $125,000 125,000 125,000 125,000 125,000 125,000 0.592 0.558 0.909 0.826 0.751 0.683 0.621 0.564 0.513 Net Cash Flows Servers 0.467 $165,000 165,000 165,000 165,000 0.424 0.386 12% 0.893 0.797 0.712 0.636 0.567 0.507 0.452 0.404 0.361 0.322 15% 0.870 0.756 0.658 0.572 0.497 0.432…arrow_forwardNet present value-unequal lives Project 1 requires an original investment of $50,100. The project will yield cash flows of $10,000 per year for 8 years. Project 2 has a computed net present value of $11,600 over a 6-year life. Project 1 could be sold at the end of 6 years for a price of $38,000. Use the Present Value of $1 at Compound Interest and the Present Value of an Annuity of $1 at Compound Interest tables shown below. Present Value of $1 at Compound Interest 6% 10% Year 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 0.943 0.890 0.840 0.792 0.747 7 0.705 0.665 0.627 0.592 0.558 0.943 1.833 2.673 3.465 4.212 4.917 0.909 5.582 0.826 0.751 0.683 0.621 0.564 0.513 0.467 0.424 0.386 0.909 1.736 2.487 3.170 3.791 4.355 12% 4.868 0.893 0.797 0.712 0.636 0.567 0.507 0.452 0.404 0.361 0.322 Present Value of an Annuity of $1 at Compound Interest Year 6% 10% 12% 15% 20% 0.893 1.690 2.402 3.037 3.605 4.111 15% 4.564 0.870 0.756 0.658 0.572 0.497 0.432 0.376 0.327 0.284 0.247 0.870 1.626 2.283 2.855 3.353…arrow_forward
- Franklin's new snowmobile cost $9,500. After his down payment of $1,500, he financed the remainder at 10% for 3 years. Use the table to find the monthly payment for the amortized loan. Find the total interest paid on the loan. Click the icon to view a table of monthly payments on a $1,000 loan. The monthly payments for this loan are $. (Round to the nearest cent as needed.) Enter your answer in the answer box and then click Check Answer. ? 1 part remaining Clear All Greck Answer javascript:doExercise(5); Copyright © 2020 Pearson Education Inc. All rights reserved. | 99 a 近arrow_forwardWinett Corporation is considering an investment in special-purpose equipment to enable the company to obtain a four-year municipal contract. The equipment costs $222,000 and would have no salvage value when the contract expires at the end of four years. Estimated annual operating results of the project are as follows. Revenue from contract sales. Expenses other than depreciation Depreciation (straight-line basis) Increase in net income from contract work $211,000 55,500 All revenue and all expenses other than depreciation will be received or paid in cash in the same period as recognized for accounting purposes. Compute the following for Winett's proposal to undertake this contract. a. Payback period b. C. a. Payback period. b. Return on average investment. (Round your percentage answer to 1 decimal place (i.e., 0.123 to be entered as 12.3).) c. Net present value of the proposal to undertake contract work, discounted at an annual rate of 10 percent. (Refer to the annuity table in…arrow_forwardPresent value of an ordinary annuity. Fill in the missing present values in the following table for an ordinary annuity:arrow_forward
- In order to buy a vacation home, Neal and Lilly took out a 20-year mortgage for $220,000 at an annual interest rate of 6%. After 10 years, they refinanced the unpaid balance of $142,125 at an annual rate of 4%. Use the table to find the monthly payments on the original loan; the monthly payments on the new loan; and the total amount saved on interest by refinancing. Click the icon to view a table of monthly payments on a $1,000 loan. The monthly payments on the original loan are $ (Type an integer or a decimal.) Enter your answer in the answer box and then click Check Answer. 2 parts remaining Clear All Check Answrer javascript:doExercise(6); 10:45 PM 10/26/2020 120arrow_forwardNumber of Years for the Loan Annual Interest 3 10 20 30 Rate 4% $29.53 $22.58 $10.12 $6.06 $4.77 5% 29.97 23.03 10.61 6.60 5.37 6% 30.42 23.49 11.10 7.16 6.00 8% 31.34 24.41 12.13 8.36 7.34 10% 32.27 25.36 13.22 9.65 8.78 12% 33.21 26.33 14.35 11.01 10.29 A borrower took out a mortgage loan for 20 years in the amount of $95,000 with an annual interest rate of 12%. a. Use the table of monthly payments on $1,000 loan, to find the monthly payment for this mortgage. $ b. Find the total interest paid on the loan. $arrow_forwardGrove Media plans to acquire production equipment for $845,000 that will be depreciated for tax purposes as follows: year 1, $329,000; year 2, $189,000; and in each of years 3 through 5, $109,000 per year. A 10 percent discount rate is appropriate for this asset, and the company's tax rate is 20 percent. Use Exhibit A.8 and Exhibit A.9. Required: a. Compute the present value of the tax shield resulting from depreciation. b. Compute the present value of the tax shield from depreciation assuming straight-line depreciation ($169,000 per year). Complete this question by entering your answers in the tabs below. Required A Required B Compute the present value of the tax shield resulting from depreciation. Note: Round PV factor to 3 decimal places. Present value of the tax shieldarrow_forward
- Increasing the down payment on a mortgage reduces both the size of the monthly payments and the total interest paid. Calculate (a) the reduction in the monthly payment by increasing the down payment by the amount specified, and (b) the amount saved on interest over the life of the loan. Assume the mortgage is for 10 years and use the amortization table to find the monthly payments. Increase in Amount of Loan Interest Rate Down Payment Down payment $191,000 12% $32,000 $15,000 Click the icon to view a table of monthly payments on a $1,000 loan. a. The monthly payment will be reduced by $ when the down payment is increased by $15,000. (Round to the nearest cent as needed.) Enter your answer in the answer box and then click Check Answer. 1 part Check Answer SO Clear All remaining javascript:doExercise(5); Copyright © 2020 Pearson Education Inc. All rights reserved. Ter 99+ a 近arrow_forwardNonearrow_forwardnaruarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning