Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. solve using excel 2. you give a loan to your frien

Solve using excel 2. You give a loan to your friend to buy equipment for his business....

60.1K

Verified Solution

Question

Finance

Solve using excel

2. You give a loan to your friend to buy equipment for hisbusiness. The friend puts $4000 of their own money as a downpayment, you lend them $12,000. The equipment is $16,000 total. Youwill charge your friend 4.0% Interest every year and will collectmonthly payments for 60 months. Inflation is 1.7% per year,constant for 5 years.

a. What is the monthly payment you will collect?

b. What is the total amount of payments you will collect?

c. What is the vehicle worth at the end of the loan term if itdepreciates in value at $150 each month?

Answer & Explanation Solved by verified expert
4.0 Ratings (812 Votes)
aLoan amountPV12000Rate    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

Solve using excel2. You give a loan to your friend to buy equipment for hisbusiness. The friend puts $4000 of their own money as a downpayment, you lend them $12,000. The equipment is $16,000 total. Youwill charge your friend 4.0% Interest every year and will collectmonthly payments for 60 months. Inflation is 1.7% per year,constant for 5 years.a. What is the monthly payment you will collect?b. What is the total amount of payments you will collect?c. What is the vehicle worth at the end of the loan term if itdepreciates in value at $150 each month?

Other questions asked by students

Q

Which of the following occurs in meiosis II but not meiosis I? Select one: A. homologous chromosomes pair B....

Biology
Q

Calculate the wavelength of each of the following frequencies of electromagnetic radiation A) 104.8 MHz (typical frequency...

Chemistry
Q

What force parallel to a frictionless plane is necessary so that a 60 0 kg...

Physics
Q

5 Consider a disk D of radius 1 We say a collection of shapes hides...

Geometry
Q

2 4 Solve Prob 2 3 with a 10 ft b 15 fi

Basic Math
Q

Suppose that $2000 is invested at a rate of 3.3%, compounded annually. Assuming that no...

Basic Math
Q

The number of hours worked, x, and the total dollars earned, y, have a strong...

Basic Math
Q

On January 1, 2020 (Year 1), Fourtier Corporation ((a calendar year end business) purchased a...

Accounting
Q

Susie's Sweet Shop has the following sales, payroll, and property factors: What are Susie's Sweet...

Accounting
Q

HELP!! I need an answer ASAP Question: When is an intangible asset that is to...

Accounting
Q

The Cutting Department of Cassel Company has the following production and cost data for July....

Accounting
Q

Given the following information for Smashville, Inc., construct an income statement for the year: ...

Finance