Finance CH 5
pdf
keyboard_arrow_up
School
Macomb Community College *
*We aren’t endorsed by this school
Course
1
Subject
Finance
Date
Feb 20, 2024
Type
Pages
4
Uploaded by SargentEchidna4784
Rate
0.1
Time
20
PMT
-500
Future Value
$28,637
Rate
0.06
Time
5
Loan
-7,000
Annual Payment
$1,662
Rate
0.05
Time
10
PMT
-500
Present Value
$3,861
Year Cash Flow
1
1,110
$ 2
970
$ 3
1,500
$ 4
1,860
$ Year Cash Flow
Present Value
1
1,110
$ $1,009.09
2
970
$ $801.65
3
1,500
$ $1,126.97
4
1,860
$ $1,270.41
Total Present Value
$4,208.12
b) What is the present value at 18 percent?
Year Cash Flow
Present Value
1
1,110
$ $940.68
2
970
$ $696.64
3
1,500
$ $912.95
4
1,860
$ $959.37
Total Present Value
$3,509.63
c) What is the present value at 24 percent?
Year Cash Flow
Present Value
1
1,110
$ $895.16
2
970
$ $630.85
3
1,500
$ $786.73
4
1,860
$ $786.73
Total Present Value
$3,099.48
Question 3
Question 6
Question 9
Mendez Company has identified an investment project with the following cash flows.
Question 10
a) If the discount rate is 10 percent, what is the present value of these cash flows?
For each of the following annuities, calculate the present value.
Present Value
Annuity Payment
Years
Interest Rate
$11,856.44
2,200
7
7%
$9,114.27
1,340
9
6%
$121,002.98
12,080
21
8%
$291,863.22
31,150
29
10%
a) How much money will you have in the account in 16 years?
Rate
0.1025
Time
16
PMT
(5,300)
$ Future Value
$194,675.02
b) How much will you have if you make deposits for 32 years?
Rate
0.1025
Time
32
PMT
(5,300)
$ Future Value
$1,122,290.11
Investment
41,000
$ Rate
0.066
Present value today
$621,212.12
a) How much will you have in the account in 3 years?
Rate
0.072
Time
3
PMT
(6,900)
$ Future Value
$8,563.42
b) How much will you have in the account in 6 years?
Rate
0.072
Time
6
PMT
(6,900)
$ Future Value
$10,627.86
c) How much will you have in the account in 12 years?
Rate
0.072
Time
12
PMT
(6,900)
$ Future Value
$16,369.77
Question 16
Spartan Credit Bank is offering 7.2 percent compounded daily on its savings accounts. Assume that you deposit $6,900 today.
Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. Use 365 days in a year.
Question 11
Question 12
Assume you deposit $5,300 at the end of each year into an account paying 10.25 percent interest.
Question 14
The Maybe Pay Life Insurance Company is trying to sell you an investment policy that will pay you and your heirs $41,000 per year forever. Assume the required return on this investment is 6.6 percent. How much will you pay for the policy?
a) What will your monthly payments be?
Rate
8.00%
Montly interest rate
0.67%
Time
48
Loan
(75,600)
$ Monthly payment
$1,845.62
b) What is the effective annual rate on this loan?
Montly interest rate
8.00%
Time
48
Effective annual rate
8.32%
Rate
11.20%
Time
32
PMT
(575)
$ Future Value
$2,120,739.09
a) If you take the first option, $8,200 per month for two years, what is the present value?
Rate
6.00%
Number of years
2
Compounding periods per year
12
PMT
(8,200)
$ Present Value
$185,015.50
b) What is the present value of the second option?
Rate
6.00%
Number of years
2
Compounding periods per year
12
PMT
(6,900)
$ Present Value
$155,683.78
Bonus
$37,000.00
Overall value
$192,683.78
Rate
8.00%
Number of years
17
PMT
(13,700)
$ Present Value
$124,966.44
Number of months
72
Compounding periods per year
12
Loan 60,000
$ PMT
(1,100)
$ Monthly interest rate
0.80%
Annual APR
9.62%
Question 17
You want to buy a new sports coupe for $75,600, and the finance office at the dealership has quoted you a loan with an APR of 8 percent for 48 months to buy the car.
Question 19
You are to make monthly deposits of $575 into a retirement account that pays an APR of 11.2 percent compounded monthly. If your first deposit will be made one month from now, how large will your retirement account be in 32 years?
You want to borrow $60,000 from your local bank to buy a new sailboat. You can afford to make monthly payments of $1,100, but no more. Assuming monthly compounding, what is the highest rate you can afford on a 72-month APR loan?
Question 21
You’ve just joined the investment banking firm of Dewey, Cheatum, and Howe. They’ve offered you two different salary arrangements. You can have $8,200 per month for the next two years, or you can have $6,900 per month for the next two years, along with a $37,000 signing bonus today. Assume the interest rate is 6 percent compounded monthly.
Question 22
Peter Lynchpin wants to sell you an investment contract that pays equal $13,700 amounts at the end of each of the next 17 years. If you require an effective annual return of 8 percent on this investment, how much will you pay for the contract today?
Question 23
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
Year
Beginning Balance
Total Payment
Interest Payment
Principal Payment
Ending Balance
1
114,000.00
$ $46,650.29
12,540.00
$ $34,110.29
79,889.71
$ 2
79,889.71
$ $46,650.29
8,787.87
$ $37,862.42
42,027.29
$ 3
42,027.29
$ $46,650.29
4,623.00
$ $42,027.29
-
$ Total Interest
25,950.87
$ Question 24
Prepare an amortization schedule for a three-year loan of $114,000. The interest rate is 11 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan?
Related Questions
MND
arrow_forward
plan A
plan B
plan C
Down payment
1,789.91
2,309.65
3,764.51
Annual payments
5,097.70
7,450.16
9,845.78
Years
20
20
20
Discount rate
12%
12%
12%
What is the present value of plan B?
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
Subject:
arrow_forward
You work for a nuclear research laboratory that is contemplating leasing a diagnostic
scanner (leasing is a very common practice with expensive, high-tech equipment). The
scanner costs $4,800,000, and it would be depreciated straight-line to zero over four
years. Because of radiation contamination, it actually will be completely valueless in four
years. You can lease it for $1,430,000 per year for four years. Assume that the tax rate is
21 percent.
Suppose the entire $4,800,000 purchase price of the scanner is borrowed. The rate on
the loan is 8 percent, and the loan will be repaid in equal annual installments.
Calculate the amount of annual loan repayment. (Do not round intermediate
calculations and round your answer to 2 decimal places, e.g., 32.16.)
Payment
Complete the schedules given below and calculate the NAL. (A negative answer should
be indicated by a minus sign. Do not round intermediate calculations and round your
answers to 2 decimal places, e.g., 32.16.)
Amortization
Year…
arrow_forward
Consider a loan of $8,000 charging interest at j12-6% with monthly payments of
$321.50 Calculate the missing amounts in the amortization table. Place the value for
A in the first answer box, B in the second and C in the third.
PMT Interest Principall Balance
8,000.00
1321.50 40.00 281.50 7,718.50
2 321.50
A
C
arrow_forward
Present Value of
an Annuity of $1
Discount Rate
Present Value of
$1 Discount Rate
Periods
8%
10%
8%
10%
0.6806
0.6209
3.9927
3.7908
0.5835
0.5132
5.2064
4.8684
0.5002
0.4241
6.2469
5.7590
Psyche Company wants to acquire Trim Company. Trim's ROI has been above average for its industry; net income has averaged
$140,000 a year more than the industry average. These "excess" earnings are expected to continue at this amount for 5 years.
Assuming a discount rate of 8%, how much goodwill will arise from Psyche's purchase of Trim?
arrow_forward
1
2 Loan Amount (BO)
3 Annual Interest Rate
4
#times per year interest accrued
5
Periodic Rate
6 Term (years)
7 #payments per year
8 Number of payments (N)
9 Balloon (balance after final payment)
10 Points paid at origination to get loan
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
$1,000,000.00
7.66%
12
0.64%
30
12
360
$0.00 AKA "Fully Amortizing"
1.50%
t
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Balance in (t): B_(t)
$1,000,000.00
Interest in (t+1): (i/m)*B_t
$6,383.33
Payment in (t+1)
$7,102.03
Balance in (t+1): B_(t+1)
$999,281.30
Principal paid in (t+1) (=PMT-INT)
$718.70
arrow_forward
Financial Accounting Question need help please
arrow_forward
Amortization schedule
Loan amount to be repaid (PV)
$25,000.00
Interest rate (r)
11.00%
Length of loan (in years)
3
a. Setting up amortization table
Formula
Calculation of loan payment
#N/A
Year
Beginning Balance
Payment
Interest
Repayment of Principal
Remaining Balance
1
2
3
b. Calculating % of Payment Representing Interest and Principal for Each Year
Year
Payment % Representing Interest
Payment % Representing Principal
Check: Total = 100%
1
2
3
Formulas
Year
Beginning Balance
Payment
Interest
Repayment of Principal
Remaining Balance
1
#N/A
#N/A
#N/A
#N/A
#N/A
2
#N/A
#N/A
#N/A
#N/A
#N/A
3
#N/A
#N/A
#N/A
#N/A
#N/A
b. Calculating % of Payment Representing Interest and Principal for Each Year
Year
Payment %…
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
Income: $4900/month
Expenses: $4800/Year
Loan Terms: 7.875%
Interest, 80%
LTV, 25 Year Loan
Cap Rate: 6.0%
Find: the NOI, value of the building, Debt Service, and Cash on Cash Return
arrow_forward
Discount rate:
6%
End of year:
1
2
4
Cash flows:
(20,000) $
5,000 $
5,000 $
5,000 $
5,000 $
5,000
What is the Net Present Value of the cash flows?
At what discount rate is the Net Present Value "0"?
Initial outlay:
5,000
Life of investment in years:
10
Amount to be received at end:
10,000
8
Rate of return:
Amount of loan:
2$
50,000
Annual payment:
2$
10,000
Interest rate:
8%
9.
How many years will it take to pay off the loan?
3.
%24
%24
%24
%24
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
Number of Loans Principal
50
100
50
100,000
250,000
300,000
Rate
4.25%
5%
Maturity
360
180
360
If these 200 loans are pooled to create a MPT, what is the starting pool balance in dollars? Assume the loans
are not seasoned before securitization.
arrow_forward
Present value of an Annuity of $1 in Arrears
Periods
4%
6%
8%
10%
12%
14%
1
0.962
0.943
0.926
0.909
0.893
0.877
2
1.886
1.833
1.783
1.736
1.690
1.647
3
2.775
2.673
2.577
2.487
2.402
2.322
4
3.630
3.465
3.312
3.170
3.037
2.914
5
4.452
4.212
3.993
3.791
3.605
3.433
6
5.242
4.917
4.623
4.355
4.111
3.889
7
6.002
5.582
5.206
4.868
4.564
4.288
8
6.733
6.210
5.747
5.335
4.968
4.639
9
7.435
6.802
6.247
5.759
5.328
4.946
10
8.111
7.360
6.710
6.145
5.650
5.216
Lucas Company is considering a project with an initial investment of $530,250 in new equipment that will yield annual net cash flows of $95,000, and will be depreciated at $75,750 per year over its seven year life. What is the internal rate of return?
a.6%
b.14%
c.10%
d.12%
e.8%
arrow_forward
Amount financed 18200 number of payments 72 monthly payment 425.08 finace charge 12405.76 whats the apr%
arrow_forward
Give me answer general accounting
arrow_forward
Monthly Payments
(Necessary to amortize a loan of $1,000)
Interest
5
10
15
20
25
30
35
40
Rate (%)
Years
Years
Years
Years
Years
Years
Years
Years
3.50
18.19
9.89
7.15
5.80
5.01
4.49
4.13
3.87
3.75
18.30
10.01
7.27
5.93
5.14
4.63
4.28
4.03
4.00
18.42
10.12
7.40
6.06
5.28
4.77
4.43
4.18
4.25
18.53
10.24
7.52
6.19
5.42
4.92
4.58
4.34
4.50
18.64
10.36
7.65
6.33
5.56
5.07
4.73
4.50
4.75
18.76
10.48
7.78
6.46
5.70
5.22
4.89
4.66
5.00
18.87
10.61
7.91
6.60
5.85
5.37
5.05
4.82
5.25
18.99
10.73
8.04
6.74
5.99
5.52
5.21
4.99
5.50
19.10
10.85
8.17
6.88
6.14
5.68
5.37
5.16
5.75
19.22
10.98
8.30
7.02
6.29
5.84
5.54
5.33
6.00
19.33
11.10
8.44
7.16
6.44
6.00
5.70
5.50
6.25
19.45
11.23
8.57
7.31
6.60
6.16
5.87
5.68
6.50
19.57
11.35
8.71
7.46
6.75
6.32
6.04
5.85
6.75
19.68
11.48
8.85
7.6
6.91
6.49
6.21
6.03
7.00
19.80
11.61
8.99
7.75
7.07
6.65
6.39
6.21
7.25
19.92
11.74
9.13
7.90
7.23
6.82
6.56
6.40
7.50
20.04
11.87
9.27
8.06
7.39
6.99
6.74
6.58
7.75
20.16
12.00
9.41
8.21
7.55
7.16
6.92
6.77
8.00…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Related Questions
- MNDarrow_forwardplan A plan B plan C Down payment 1,789.91 2,309.65 3,764.51 Annual payments 5,097.70 7,450.16 9,845.78 Years 20 20 20 Discount rate 12% 12% 12% What is the present value of plan B?arrow_forwardIn 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_forward
- Subject:arrow_forwardYou work for a nuclear research laboratory that is contemplating leasing a diagnostic scanner (leasing is a very common practice with expensive, high-tech equipment). The scanner costs $4,800,000, and it would be depreciated straight-line to zero over four years. Because of radiation contamination, it actually will be completely valueless in four years. You can lease it for $1,430,000 per year for four years. Assume that the tax rate is 21 percent. Suppose the entire $4,800,000 purchase price of the scanner is borrowed. The rate on the loan is 8 percent, and the loan will be repaid in equal annual installments. Calculate the amount of annual loan repayment. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Payment Complete the schedules given below and calculate the NAL. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Amortization Year…arrow_forwardConsider a loan of $8,000 charging interest at j12-6% with monthly payments of $321.50 Calculate the missing amounts in the amortization table. Place the value for A in the first answer box, B in the second and C in the third. PMT Interest Principall Balance 8,000.00 1321.50 40.00 281.50 7,718.50 2 321.50 A Carrow_forward
- Present Value of an Annuity of $1 Discount Rate Present Value of $1 Discount Rate Periods 8% 10% 8% 10% 0.6806 0.6209 3.9927 3.7908 0.5835 0.5132 5.2064 4.8684 0.5002 0.4241 6.2469 5.7590 Psyche Company wants to acquire Trim Company. Trim's ROI has been above average for its industry; net income has averaged $140,000 a year more than the industry average. These "excess" earnings are expected to continue at this amount for 5 years. Assuming a discount rate of 8%, how much goodwill will arise from Psyche's purchase of Trim?arrow_forward1 2 Loan Amount (BO) 3 Annual Interest Rate 4 #times per year interest accrued 5 Periodic Rate 6 Term (years) 7 #payments per year 8 Number of payments (N) 9 Balloon (balance after final payment) 10 Points paid at origination to get loan 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 $1,000,000.00 7.66% 12 0.64% 30 12 360 $0.00 AKA "Fully Amortizing" 1.50% t 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Balance in (t): B_(t) $1,000,000.00 Interest in (t+1): (i/m)*B_t $6,383.33 Payment in (t+1) $7,102.03 Balance in (t+1): B_(t+1) $999,281.30 Principal paid in (t+1) (=PMT-INT) $718.70arrow_forwardFinancial Accounting Question need help pleasearrow_forward
- Amortization schedule Loan amount to be repaid (PV) $25,000.00 Interest rate (r) 11.00% Length of loan (in years) 3 a. Setting up amortization table Formula Calculation of loan payment #N/A Year Beginning Balance Payment Interest Repayment of Principal Remaining Balance 1 2 3 b. Calculating % of Payment Representing Interest and Principal for Each Year Year Payment % Representing Interest Payment % Representing Principal Check: Total = 100% 1 2 3 Formulas Year Beginning Balance Payment Interest Repayment of Principal Remaining Balance 1 #N/A #N/A #N/A #N/A #N/A 2 #N/A #N/A #N/A #N/A #N/A 3 #N/A #N/A #N/A #N/A #N/A b. Calculating % of Payment Representing Interest and Principal for Each Year Year Payment %…arrow_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_forwardIncome: $4900/month Expenses: $4800/Year Loan Terms: 7.875% Interest, 80% LTV, 25 Year Loan Cap Rate: 6.0% Find: the NOI, value of the building, Debt Service, and Cash on Cash Returnarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning

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