Question

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

Solve using excel

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

a.) What is the NPV of the loan assuming it is paid each month on time?

b.) What is the opportunity cost of the loan you give to your friend if you could invest the same amount and receive a 4.5% return each month?

c.). Given the opportunity cost would you lend your friend the money?

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Hi there, Please find the solution of the above mentioned problem. Thanks.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
6. You loan some money to a friend and he agrees to pay you $200 at...
6. You loan some money to a friend and he agrees to pay you $200 at the end of each month for the next 2.5 years. Using a rate of 6.3%/year, calculate what this stream of anticipated payments from your friend is worth in today’s dollar terms. In other words, if your friend promises to make these payments, what would be a fair amount to loan to him today?
You raise some money today from your friend. He agrees to loan you the money you...
You raise some money today from your friend. He agrees to loan you the money you need, if you make payments of $40 a month for the next one year. In keeping with his reputation, he requires that the first payment be paid today. He also charges you 2 percent interest per month. How much money are you borrowing? ADue PV =
15 years from now, your 2-year old son will be attending Harvard. You have determined he...
15 years from now, your 2-year old son will be attending Harvard. You have determined he will need $85,000 per year for tuition and living expenses. In 15 years, you will give him a lump sum payment for the entire amount he will need, assuming that he will be able to invest the money not yet needed at 4.5% interest. You have found an investment opportunity that will yield an annual return of 6.5% on your monthly payments. How much...
15 years from now, your 2-year old son will be attending Harvard. You have determined he...
15 years from now, your 2-year old son will be attending Harvard. You have determined he will need $85,000 per year for tuition and living expenses. In 15 years, you will give him a lump sum payment for the entire amount he will need, assuming that he will be able to invest the money not yet needed at 4.5% interest. You have found an investment opportunity that will yield an annual return of 6.5% on your monthly payments. How much...
15 years from now, your 2-year old son will be attending Harvard.  You have determined he will...
15 years from now, your 2-year old son will be attending Harvard.  You have determined he will need $85,000 per year for tuition and living expenses.  In 15 years, you will give him a lump sum payment for the entire amount he will need, assuming that he will be able to invest the money not yet needed at 4.5% interest.  You have found an investment opportunity that will yield an annual return of 6.5% on your monthly payments.  How much will you have to...
You want to buy your dream house. You currently have $15,000 saved and you need to...
You want to buy your dream house. You currently have $15,000 saved and you need to have a 10% down payment plus an additional 5% of the loan amount for closing costs. Assume the cost of the house is $956,216. You can earn 7.5% per year in a savings account per year. How long will it be before you have enough money for the down payment and closing costs? Given your current credit, you secure a 15-year fixed rate mortgage...
Use an Excel worksheet to answer the following five car loan problems you borrowed money from...
Use an Excel worksheet to answer the following five car loan problems you borrowed money from your local bank to purchase a car. The bank requires you to repay the loan over 48 months and charges a fixed, annual interest rate of 6 percent. The amount of your loan is $25,000 a,How much will your loan payment be each month? b,How much of the first loan payment will go toward principal? c,How much interest will you pay during the 1st...
please solve the requirements 1 to 4 using this data. thanks Daisy, a friend who is...
please solve the requirements 1 to 4 using this data. thanks Daisy, a friend who is an excellent baker, has decided to open a cupcake store to sell gourmet cupcakes. Daisy has asked you if you will be willing to loan the company $50,000 at an interest rate of 4% that will be paid back over 5 years. You will analyze the business to determine if you will loan Daisy the money. The business is scheduled to launch on January...
You plan to open your own wine business. The cost of plant, property and equipment is...
You plan to open your own wine business. The cost of plant, property and equipment is $500,000. You already have the money for the initial cost which you could invest at the same level of risk and expect to earn 10%. You think you can sell 1 million bottles/year at $1/per bottle. Your costs are $200,000/per year to keep the factory running plus $0.50/bottle produced. Your tax rate is 50% and you plan to operate this business for 5-years. You...
You need a 30-year, fixed-rate mortgage to buy a new home for $240,000. Your mortgage bank...
You need a 30-year, fixed-rate mortgage to buy a new home for $240,000. Your mortgage bank will lend you the money at a 9.1 percent APR for this 360-month loan. However, you can afford monthly payments of only $950, so you offer to pay off any remaining loan balance at the end of the loan in the form of a single balloon payment. Required: How large will this balloon payment have to be for you to keep your monthly payments...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT