Investor #1 decided to loan you the $300,000, paying all of the interest (8% per year)...
Investor #1 decided to loan you the $300,000, paying all of the interest (8% per year) and principal in one lump sum at the end of 5 years. · Investor #2 offers you the $300,000, paying interest at the rate of 8% per year for 4 years and then a final payment of interest and principal at the end of the 5th year.
how is this inputted in excel formula?
Homework Answers
For Investor 1, function FV can be used. The screenshot of Excel is provided below.
Amount at the end of 5 years to paid = $440,798.2.
For Investor 2
Interest Paid for the first 4 years = 24000
Amount paid in the last year =Interest in the last year + Outstanding Principal
= 300000 + 24000 =324000
Add Answer to:
Investor #1 decided to loan you the $300,000, paying all of the
interest (8% per year)...
Investor #2 offers you the $300,000 paying interest at the rate of 8% per year for...
Investor #2 offers you the $300,000 paying interest at
the rate of 8% per year for 4 years and then a final payment of
interest and principal at the end of the 5th year . find annual
interest payment , year 5 payment , total payment and interest
paid
DataRevicwiew Times New Roman 12 A" AT Av 1:11 ////EEi@werg. & Center w $. % , y Pay interest at the rate of 8%per year for 4 years and then a...
Analyze and calculate the following scenarios in 525 words, including which one would you choose and why, and which...
Analyze and calculate the following scenarios in 525 words, including which one would you choose and why, and which financing option is best for your busines: Investor #1 decided to loan you the $300,000, paying all of the interest (8% per year) and principal in one lump sum at the end of 5 years. Investor #2 offers you the $300,000, paying interest at the rate of 8% per year for 4 years and then a final payment of interest and principal at the...
Analyze and calculate the following scenarios in 525 words, including which one would you choose and why, and which...
Analyze and calculate the following scenarios in 525 words, including which one would you choose and why, and which financing option is best for your busines: Investor #1 decided to loan you the $300,000, paying all of the interest (8% per year) and principal in one lump sum at the end of 5 years. Investor #2 offers you the $300,000, paying interest at the rate of 8% per year for 4 years and then a final payment of interest and principal at the...
show all the steps followed in Excel Times New Roman12 A"AHEE D16 수 1 Pay interest-the...
show all the steps followed in Excel
Times New Roman12 A"AHEE D16 수 1 Pay interest-the rate of 8% per year for 4 years and then a final payment of merest and principal a teed fte se year 2. 3 Amount 4 Period (years) S Interes rate 300,000 8% 8 Anmual Interest Payment- 9 Year 5 Payment 12 13 14 15 asl 17 Investor #2 offers you the $300,000 paying interest at the rate of 8% per year for 4...
You have $50,000 invested in an account paying 3.50%. If you just finished paying your total...
You have $50,000 invested in an account paying 3.50%. If you just finished paying your total college expenses for the coming year and your college costs $19,000 per year, how many years will your money last? (Treat your costs like an annuity with the first payment one year from today.) You have a choice between a lottery lump sum payout of $10,000,000 today or a series of twenty-five annual annuity payments $800,000 (first payment one year from today). At an...
4 Balloons You are an important local real estate investor; you just got a $10,000,000 balloon...
4 Balloons You are an important local real estate investor; you just got a $10,000,000 balloon loan to buy a new office building in your home town. The nominal maturity of the loan is 30 years, but the loan has a 10-year balloon payment. In other words, the loan will end at the end of the 10th year, and the outstanding balance will be paid off in a lump sum at that time. The interest on the loan is 6.7%...
Consider a 15-year home mortgage loan with a fixed APR of 4.8%. Which of the following...
Consider a 15-year home mortgage loan with a fixed APR of 4.8%. Which of the following statements is NOT correct? Select one: O a. If you want to entirely pay off the loan at the end of year 10, the required lump sum payment is equal to the present value of 60 monthly payments O b. The monthly interest amount is calculated by 4.8% times the loan balance at the beginning of the month O c. The scheduled monthly loan...
6. You would like to borrow $10,000 at an interest rate of 8 percent per year...
6. You would like to borrow $10,000 at an interest rate of 8 percent per year for five years. You agree to make interest and principal payments totaling $2,401.49 at the end of each year. Prepare a loan amortization schedule for each of the five years, showing the beginning principal balance, the total payment of $2,401.49, the interest component of the payment, the principal component of the payment, and the ending principal balance. a. Fill in the blank spaces in...
repare an amortization schedule for a five-year loan of $45,000. The interest rate is 8% per...
repare an amortization schedule for a five-year loan of $45,000. The interest rate is 8% per year, and the loan calls for equal annual payments. (Do not round intermediate calculations. Enter all amount as positive value. Round the final answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.) Year Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance 1 $ $ $ $ $ 2 3 4 5 How much interest...
You plan to purchase a $300,000 house using a mortgage obtained from your bank. The Mortgage...
You plan to purchase a $300,000 house using a mortgage obtained from your bank. The Mortgage rate offered to you is 4.50 percent for a 15 year Mortgage. You will make a down payment of 20 percent of the purchase price. Either using formula or Excel, calculate: A. Calculate your monthly payments on this mortgage? B. What is your loan balance at the end of 4 years (48 payment)? C. What is your loan balance at the end of 10...
Investor #2 offers you the $300,000 paying interest at
the rate of 8% per year for 4 years and then a final payment of
interest and principal at the end of the 5th year . find annual
interest payment , year 5 payment , total payment and interest
paid
DataRevicwiew Times New Roman 12 A" AT Av 1:11 ////EEi@werg. & Center w $. % , y Pay interest at the rate of 8%per year for 4 years and then a...
show all the steps followed in Excel
Times New Roman12 A"AHEE D16 수 1 Pay interest-the rate of 8% per year for 4 years and then a final payment of merest and principal a teed fte se year 2. 3 Amount 4 Period (years) S Interes rate 300,000 8% 8 Anmual Interest Payment- 9 Year 5 Payment 12 13 14 15 asl 17 Investor #2 offers you the $300,000 paying interest at the rate of 8% per year for 4...
4 Balloons You are an important local real estate investor; you just got a $10,000,000 balloon loan to buy a new office building in your home town. The nominal maturity of the loan is 30 years, but the loan has a 10-year balloon payment. In other words, the loan will end at the end of the 10th year, and the outstanding balance will be paid off in a lump sum at that time. The interest on the loan is 6.7%...
Consider a 15-year home mortgage loan with a fixed APR of 4.8%. Which of the following statements is NOT correct? Select one: O a. If you want to entirely pay off the loan at the end of year 10, the required lump sum payment is equal to the present value of 60 monthly payments O b. The monthly interest amount is calculated by 4.8% times the loan balance at the beginning of the month O c. The scheduled monthly loan...
You plan to purchase a $300,000 house using a mortgage obtained from your bank. The Mortgage rate offered to you is 4.50 percent for a 15 year Mortgage. You will make a down payment of 20 percent of the purchase price. Either using formula or Excel, calculate: A. Calculate your monthly payments on this mortgage? B. What is your loan balance at the end of 4 years (48 payment)? C. What is your loan balance at the end of 10...
Most questions answered within 3 hours.
-
Individuals in a species of moth vary in wing color from white to
black, but all...
asked 5 minutes ago -
The following standards for variable manufacturing overhead have
been established for a company that makes only...
asked 16 minutes ago -
The United States government wanted to determine what proportion
of Americans approve of the current president,...
asked 31 minutes ago -
2-N stone is dropped from the top of a cliff. The stone hits the
ground 3...
asked 31 minutes ago -
Vitamins participate in metabolic reactions in their coenzyme
forms . Match the following reactions to the respective...
asked 33 minutes ago -
We have developed a new mobile device and wish to gain insight
into the price that...
asked 56 minutes ago -
12.8 ml of a solution is run into an empty flask, from a buret.
The mass...
asked 48 minutes ago -
Using java:
Use the following starter code:
public class HandsOn01 {
public //// insert your code...
asked 46 minutes ago -
Two speakers are placed along a wall 3 m apart. They are in
phase and emitting...
asked 58 minutes ago -
Determine the magnitude of the complex number z = 3 – j * 4
using the...
asked 52 minutes ago -
Why don’t we give poor people more cash welfare instead of
in-kind transfers like food stamps,...
asked 59 minutes ago -
Two companies, A and B, decide to acquire asset worth $15
million. Company A decides to...
asked 59 minutes ago