Module 6_Travel Loan (3)
xlsx
keyboard_arrow_up
School
University of Alabama *
*We aren’t endorsed by this school
Course
200
Subject
Accounting
Date
Apr 3, 2024
Type
xlsx
Pages
6
Uploaded by DoctorInternet13806
Vacation LocationVacation DurationPrice
Interest RateLoan Payment Time (in years)
Eastern Europe
2 weeks
$2,000
5.5%
1
Western Europe
2 weeks
$3,000
6.0%
1
Eastern Europe
3 weeks
$3,500
5.5%
2
Eastern Europe
4 weeks
$4,000
6.0%
2
Western Europe
4 weeks
$5,000
6.5%
2
Payment Per Month
Total Amount Paid
Total Interest Paid
$232.06
$2,784.70
$784.70
$357.83
$4,293.97
$1,293.97
$266.13
$6,387.01
$2,887.01
$318.72
$7,649.18
$3,649.18
$416.99
$10,007.72
$5,007.72
Module 6: T
A new aspect of the business has
can apply for a loan to help pay fo
are only available to students who
least 2 weeks. Because the costs
depending on how you travel, wh
destination, different loan packag
you have decided to take out a lo
offers but are unsure whether you
Update this spreadsheet to calcu
1) Update Column F with the p
situations. (hint: use the PMT fun
2) Update Column G with the t
loan for each of these situations
3) Update Column H with the t
loan for each of these situations
Travel Loan Facility
s been added to Campus Travel. Students or their travels. However, loans for travel o are traveling outside the country for at s for this type of international travel differ here you stay, and what you do at the ges are available. For a month in Europe, oan. You have already looked at several u can afford it.
ulate the following information:
payment per month for each of these nction to calculate the payments)
total amount paid over the duration of the total interest paid over the duration of 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
51375
95287
Questions
Score
Max Points
Data in cell(s): F2, in worksheet: CH6
0.5
1
Data in cell(s): F3, in worksheet: CH6
0.5
1
Data in cell(s): F4, in worksheet: CH6
0.5
1
Data in cell(s): F5, in worksheet: CH6
0.5
1
Data in cell(s): F6, in worksheet: CH6
0.5
1
Data in cell(s): G2, in worksheet: CH6
0
1
Data in cell(s): G3, in worksheet: CH6
0
1
Data in cell(s): G4, in worksheet: CH6
0
1
Data in cell(s): G5, in worksheet: CH6
0
1
Data in cell(s): G6, in worksheet: CH6
0
1
Data in cell(s): H2, in worksheet: CH6
0
1
Data in cell(s): H3, in worksheet: CH6
0
1
Data in cell(s): H4, in worksheet: CH6
0
1
Data in cell(s): H5, in worksheet: CH6
0
1
Data in cell(s): H6, in worksheet: CH6
0
1
Total Score
2.5
15
Feedback
Check your answer. The duration of the loan is 1 year or 12 months.
Check your answer. The duration of the loan is 1 year or 12 months.
Check your answer. The duration of the loan is 1 year or 12 months.
Check your answer. The duration of the loan is 1 year or 12 months.
Check your answer. The duration of the loan is 1 year or 12 months.
Check your answer. You should be using the Price and Total Amount Paid Columns.
Check your answer. You should be using the Price and Total Amount Paid Columns.
Check your answer. You should be using the Price and Total Amount Paid Columns.
Check your answer. You should be using the Price and Total Amount Paid Columns.
Check your answer. You should be using the Price and Total Amount Paid Columns.
16.6667%
In your 3rd argument, your PV is the present value or the current price of the loan. The remaining arguments are optional and n
formula.
In your 3rd argument, your PV is the present value or the current price of the loan. The remaining arguments are optional and n
formula.
In your 3rd argument, your PV is the present value or the current price of the loan. The remaining arguments are optional and n
formula.
In your 3rd argument, your PV is the present value or the current price of the loan. The remaining arguments are optional and n
formula.
In your 3rd argument, your PV is the present value or the current price of the loan. The remaining arguments are optional and n
formula.
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
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
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
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
Loan
$
26,000
Down Payment
$
5,000
Time
36
months
Rate
11
%
Monthly Payments?
Calculate the monthly payment by using the loan amortization table
arrow_forward
question on the pic
arrow_forward
Quarter-end payments of $1,480 are made to settle a loan of $37,480 in 9 years. What
is the effective interest rate?
0.00%
Round to two decimal places
SUBMIT QUESTION
0 0 13 540 O
SAVE PROGRESS
SUBMIT
ENG
US
arrow_forward
Pdylmelnt
Period
Compounung
Frequency
PenouiL
ruture
Payment
Annuity
Rate
Value
Every 3
months
1. $2,425
7 years
4.75%
Quarterly
Every
month
6 years
2.50%
Monthly
2. $2,625
4.25%
Semi-annually
Every 6
months
3. $2,800
5 years
4. $2,100
Every year
8 years
6.25%
Annually
arrow_forward
Determine the monthly payment for the installment loan. Use the installment payment
formula m =
1-
Amount
Financed (P)
$1,440
O A. $179.15
B. $35.15
O C. $125.26
O D. $366.02
P
n
1+)
- not
Annual Percentage
Rate (r)
8%
Number of Payments
per Year (n)
12
Time
in Years (t)
4
arrow_forward
PROBLEMS
1. What is the annual rate of interest if P265 is earned in four
months on an investment of P15,000?
Ans. 5.3%
2. A loan of P2,000 is made for a period of 13 months, from
January 1 to January 31 the following year, at a simple interest rate
of 20%. What future amount is due at the end of the loan period?
Ans. P2.433.33
3. If you borrow money from your friend with simple interest of
12%, find the present worth of P20,000, which is due at the end of
nine months.
Ans. P18.348.62
arrow_forward
Part III: Loan comparison
Consider the following loan information.
term
loan A
180
loan B
180
months
amt $375,000
$375,000
rate 6.0%
7.0%
points
3%
1%
prepay
2%
1%
7. Calculate the loan payments and APR for each loan.
8
Create a spreadsheet & chart which compares the effective cost of borrowing (EBC) under Loan A
vs. Loan B for each year of loan repayment.
arrow_forward
Part a. Loan payments you borrow $100,000 over a period of 30 years at a fixed APR of 5.5% calculate the monthly payment
Part b. Determine the total amount paid, then figure out what percentage is paid towards the principal and what percentage is paid for interest.
Please solve part A and B they go together. I included an example problem
arrow_forward
Saved
Prepare an amortization schedule for a five-year loan of $70,000. The interest rate is 9
percent per year, and the loan calls for equal annual payments. (Do not round
intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.
Leave no cells blank - be certain to enter "O" wherever required.)
Year
Beginning Balance
Total Payment
Interest Payment Principal Payment
Ending Balance
1
3
4.
How much interest is paid in the third year? (Do not round intermediate-calculations
2.
5
arrow_forward
Its about annuities
arrow_forward
Payment Calculator
Property Location
Fullerton
Payments per year
12
Property Cost
$750,000
Total Payments
360
Down Payment
$75,000
Interest (APR)
4.00%
Loan Amount
$675,000
Payment (per month)
Period (Years)
30
Pleasae use the formula PMT to determine the payment per month.
arrow_forward
Find the APR (true annual interest rate), to the nearest half percent, for the following loan.
Finance
Number of
Monthly Payments
Charge
$1110
Amount
Financed
$5700
48
Click the icon to view the annual percentage rate table.
The annual percentage rate is %.
arrow_forward
a. Annual payment
b. Semiannual payments
c. Quarterly payments
d. Monthly payments
If you borrow $9,500 at $760 interest for one year, what is your annual interest cost for the following payment plan? (Round the final
answers to 2 decimal places.)
Effective rate
elp Save & Exit
% 4
Submi
arrow_forward
Frequency of
Payments
Number of
Number of
Annual Rate Years Involved Payments Involved
Case A
10%
17
17
Annually
Case B
10%
8
Annually
Case C
7%
8
16
Semiannually
arrow_forward
General Accounting question
arrow_forward
I want to this question answer general Accounting
arrow_forward
TABLE 14.2
Loan amortization table (monthly payment per $1,000 to pay principal and interest on installment loan)
Terms in
months
6
12
18
24
30
36
42
48
54
60
7.50%
$ 170.34
86.76
58.92
45.00
36.66
31.11
27.15
24.18
21.88
20.04
8.00%
$ 170.58
86.99
59.15
45.23
36.89
31.34
27.38
24.42
22.12
20.28
8.50%
$ 170.83
87.22
59.37
45.46
37.12
31.57
27.62
24.65
22.36
20.52
9.00%
$ 171.20
87.46
59.60
45.69
37.35
31.80
27.85
24.77
22.59
20.76
10.00%
$171.56
87.92
60.06
46.14
37.81
32.27
28.32
25.36
23.07
21.25
10.50%
$ 171.81
88.15
60.29
46.38
38.04
32.50
28.55
25.60
23.32
21.49
11.00%
$ 172.05
88.38
60.52
46.61
38.28
32.74
28.79
25.85
23.56
21.74
11.50%
$ 172.30
88.62
60.75
46.84
38.51
32.98
29.03
26.09
23.81
21.99
12.00%
$ 172.55
88.85
60.98
47.07
38.75
33.21
29.28
26.33
24.06
22.24
12.50%
$ 172.80
89.08
61.21
47.31
38.98
33.45
29.52
26.58
24.31
22.50
13.00%
$ 173.04
89.32
61.45
47.54
39.22
33.69
29.76
26.83
24.56
22.75
13.50%
$ 173.29
89.55
61.68
47.78
39.46
33.94
30.01
27.08
24.81
23.01
14.00%…
arrow_forward
KE
Find the equated date at which the originat payments are equivalent to the single payment State your answer in years and months (from 0 to 11 months)
Original Payments
Single Payment
$1047 00 due today and
$1308.00 due in 4 years
Interest
Rate
5%
Frequency of
Conversion
semi-annually
$2624 59
In year(s) and month(s) the single payment will be equivalent to the original payments
arrow_forward
Prepare an amortization schedule for a five year loan of $58,500. The interest rate is 6% per year and the loan cost for equal
annual payments. How much interest is paid in the third year? how much total interest is paid over the life of the loan?
Loan amount $
Interest rate
Loan term
Output area:
58,500
6%
5
Loan payment
$13,887.69
Year Beginning balance
1 $
58,500.00
Total payment Interest paid Principal paid Ending balance
$ 13,887.69 $ 3,510.00 $ 10,377.69 $
48,122.31
2
3
4
5
Total interest paid over life of loan
arrow_forward
Single-payment loan repaymentA person borrows $200 to be repaid in 8 years with 14% annually compounded interest. The loan may be repaid at the end of anyearlier
year with no prepayment penalty. a.What amount will be due if the loan is repaid at the end of year 1? b.What is the repayment at the end of year 4? c.What amount
is due at the end of the eighth year? Copyright | Prentice Hall | Principles of Managerial Finance | Edition 13 | swiningerdc@aol.com | Printed from
www.Transtutors.com
From: undefined
Source:ISBN: 0132997169 | Title: Principles of Managerial Finance | Publisher: Prentice Hall
arrow_forward
Given
Principal $10,000, Interest Rate 8%, Time 240 days (use ordinary interest)
Partial payments:
On 100th day, $4,000
On 180th day, $2,000
a. Use the U.S. Rule to solve for total interest cost
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
Related Questions
- 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_forwardAmortization 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_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
- Quarter-end payments of $1,480 are made to settle a loan of $37,480 in 9 years. What is the effective interest rate? 0.00% Round to two decimal places SUBMIT QUESTION 0 0 13 540 O SAVE PROGRESS SUBMIT ENG USarrow_forwardPdylmelnt Period Compounung Frequency PenouiL ruture Payment Annuity Rate Value Every 3 months 1. $2,425 7 years 4.75% Quarterly Every month 6 years 2.50% Monthly 2. $2,625 4.25% Semi-annually Every 6 months 3. $2,800 5 years 4. $2,100 Every year 8 years 6.25% Annuallyarrow_forwardDetermine the monthly payment for the installment loan. Use the installment payment formula m = 1- Amount Financed (P) $1,440 O A. $179.15 B. $35.15 O C. $125.26 O D. $366.02 P n 1+) - not Annual Percentage Rate (r) 8% Number of Payments per Year (n) 12 Time in Years (t) 4arrow_forward
- PROBLEMS 1. What is the annual rate of interest if P265 is earned in four months on an investment of P15,000? Ans. 5.3% 2. A loan of P2,000 is made for a period of 13 months, from January 1 to January 31 the following year, at a simple interest rate of 20%. What future amount is due at the end of the loan period? Ans. P2.433.33 3. If you borrow money from your friend with simple interest of 12%, find the present worth of P20,000, which is due at the end of nine months. Ans. P18.348.62arrow_forwardPart III: Loan comparison Consider the following loan information. term loan A 180 loan B 180 months amt $375,000 $375,000 rate 6.0% 7.0% points 3% 1% prepay 2% 1% 7. Calculate the loan payments and APR for each loan. 8 Create a spreadsheet & chart which compares the effective cost of borrowing (EBC) under Loan A vs. Loan B for each year of loan repayment.arrow_forwardPart a. Loan payments you borrow $100,000 over a period of 30 years at a fixed APR of 5.5% calculate the monthly payment Part b. Determine the total amount paid, then figure out what percentage is paid towards the principal and what percentage is paid for interest. Please solve part A and B they go together. I included an example problemarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education