Module 6_Travel Loan (3)

xlsx

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

Report
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