Homework Answers
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE
![01:53 @ vo a 1x ENG 17-03-202021 ... o X x fix A470 ДА 453 В 454 100000 3.75% 25 300 0.312500% 514.13 (=PMT(C461,C460,-C457)]](http://img.homeworklib.com/questions/0a41c570-7a81-11ea-8bcd-3d389216020b.png?x-oss-process=image/resize,w_560)
Add Answer to:
Cof It Up LLC borrowed $100,000 at 3.75% APR for 25 years to purchase a building...
Problem 4 Today is July 1, 2000. You've just borrowed $100,000 to purchase a house. The...
Problem 4 Today is July 1, 2000. You've just borrowed $100,000 to purchase a house. The terms of the loan are 6% APR with monthly compounding. It's a standard 30 year loan, with 360 payments, which occur at the end of each month. Part (A) owe? Immediately after you make your 57th payment, how much money do you still Part (B) Immediately after you make your 359th payment, how much do you stll owe? Part (C) What proportion of the...
(25 Points) 2. You have decided to purchase a new car and trade-in your old car....
(25 Points) 2. You have decided to purchase a new car and trade-in your old car. The car dealer has offered you a trade-in value of $25,000 on your old car. The car dealer will finance the remaining cost of the new car; however, you have decided that the maximum monthly car payment that you can afford is $500.00. Your loan rate will be 6 percent APR and you will be financing for 5 years (60 monthly payments). What is...
You are planning to purchase a new house or condominium to use as your primary residence....
You are planning to purchase a new house or condominium to use as your primary residence. This assignment will analyze some of the financial aspects of doing so. The final purchase price is $420,000 and, if you need a mortgage from the bank, your down payment will have to be 20% of the purchase price. The mortgage is a 30-year fixed rate loan with an Annual Percentage Rate (APR) of 6.00%. You will incur a one-time closing cost of $6,500...
Calculate a 30 year amortization schedule in excel for the purchase of an office building. Here are the details: The bui...
Calculate a 30 year amortization schedule in excel for the purchase of an office building. Here are the details: The building costs $250,000. You are able to obtain a mortgage loan for 90% of the value. You must come up with cash for the remaining 10% The mortgage loan is a fixed rate loan at 6% interest per year using simple interest with a 30/360 formula. Problem 1 - Calculate the monthly payment of the loan. Problem 2 - Prepare...
In month 10, the payment amount is $183.36. Of this payment amount, $ repays the principal....
In month 10, the payment amount is $183.36. Of this payment amount, $ repays the principal. pays interest, and You can see from this sample repayment schedule that the repayment amount generally remains the same from month to month. However, as the months progress, a percentage of the payment pays interest, and a percentage repays the principal. The add-on method is a widely used technique for computing interest on installment loans. With the add-on method, interest is calculated by applying...
Please, I need someone to help me to solve this problem! Your success in business thus...
Please, I need someone to help me to solve this problem! Your success in business thus far has put you in a position to purchase a home for $500,000 located close to the university you attend. You plan to pay a 20% down payment of $100,000 and borrow the remaining $400,000. You need to decide on a mortgage, and realize you can apply the skills you have acquired in the last several chapters to evaluate your choices. To find the...
Apr. 8 Issued a $8,800, 75-day, 8% note payable in payment of an account with Bennett Company May 15 Borrowed $...
Apr. 8 Issued a $8,800, 75-day, 8% note payable in payment of an account with Bennett Company May 15 Borrowed $40,000, 60-day, 9% note from Lincoln Bank. Jun. 22 Paid Bennett Company the principal and interest due on the April 8 note payable. Jul. 6 Purchased $16,000 of merchandise from Bolton Company, signed an Jul 14 Paid the May 15 note due Lincoln Bank Oct. 2 Borrowed $28,000, 120-day, 12% note from Lincoln Bank. Oct. 4 Defaulted on the note...
may I please have help with number 21 and 22 20. You borrow S 100,000 mortgage...
may I please have help with number 21 and 22
20. You borrow S 100,000 mortgage with monthly payments. You can either choose 15-year term with interest rate 7%, or choose 30-year term with interest nte 8% 1f both loans are held to maturity, what is the difference of total interest payment between these two mortgages? a. $84,854 b. $102.366 $125.786 d. None of the above 21 You borrow si 10,000 at 6% for 30 years with monthly payments. You...
Sue will need $120,000 to refurbish her house at the comer of a main road into a cake shop in 5 years. She has a s...
Sue will need $120,000 to refurbish her house at the comer of a main road into a cake shop in 5 years. She has a saving account which earn 3.47% p.a. compounding quarterly and she is able to deposit $800 into that account at the end of each month for 5 years. a) Will Sue have enough money after 5 years? If not, how much is in short? Show all calculations. (4 marks) b) Even if Sue may not have...
YO16_XL_CH11_GRADER_PS1_HW - Loan Analysis 1.4 Project Description: Janette Franklin, owner of Frank Solutions, LLC, is considering...
YO16_XL_CH11_GRADER_PS1_HW - Loan Analysis
1.4
Project Description:
Janette Franklin, owner of Frank Solutions, LLC, is
considering borrowing $30,000 to finance the renovation of her
office building. She has been given three different loan options
with various terms and interest rates. She knows that she can only
afford to make payments of $530.00 a month and needs your help to
determine which loan option is best.
Instructions:
Step
Instructions
Points Possible
1
Start Excel. Open the file named
e06ch11_grader_h1_Loans.xlsx. Save the...
Problem 4 Today is July 1, 2000. You've just borrowed $100,000 to purchase a house. The terms of the loan are 6% APR with monthly compounding. It's a standard 30 year loan, with 360 payments, which occur at the end of each month. Part (A) owe? Immediately after you make your 57th payment, how much money do you still Part (B) Immediately after you make your 359th payment, how much do you stll owe? Part (C) What proportion of the...
(25 Points) 2. You have decided to purchase a new car and trade-in your old car. The car dealer has offered you a trade-in value of $25,000 on your old car. The car dealer will finance the remaining cost of the new car; however, you have decided that the maximum monthly car payment that you can afford is $500.00. Your loan rate will be 6 percent APR and you will be financing for 5 years (60 monthly payments). What is...
You are planning to purchase a new house or condominium to use as your primary residence. This assignment will analyze some of the financial aspects of doing so. The final purchase price is $420,000 and, if you need a mortgage from the bank, your down payment will have to be 20% of the purchase price. The mortgage is a 30-year fixed rate loan with an Annual Percentage Rate (APR) of 6.00%. You will incur a one-time closing cost of $6,500...
In month 10, the payment amount is $183.36. Of this payment amount, $ repays the principal. pays interest, and You can see from this sample repayment schedule that the repayment amount generally remains the same from month to month. However, as the months progress, a percentage of the payment pays interest, and a percentage repays the principal. The add-on method is a widely used technique for computing interest on installment loans. With the add-on method, interest is calculated by applying...
Apr. 8 Issued a $8,800, 75-day, 8% note payable in payment of an account with Bennett Company May 15 Borrowed $40,000, 60-day, 9% note from Lincoln Bank. Jun. 22 Paid Bennett Company the principal and interest due on the April 8 note payable. Jul. 6 Purchased $16,000 of merchandise from Bolton Company, signed an Jul 14 Paid the May 15 note due Lincoln Bank Oct. 2 Borrowed $28,000, 120-day, 12% note from Lincoln Bank. Oct. 4 Defaulted on the note...
may I please have help with number 21 and 22
20. You borrow S 100,000 mortgage with monthly payments. You can either choose 15-year term with interest rate 7%, or choose 30-year term with interest nte 8% 1f both loans are held to maturity, what is the difference of total interest payment between these two mortgages? a. $84,854 b. $102.366 $125.786 d. None of the above 21 You borrow si 10,000 at 6% for 30 years with monthly payments. You...
Sue will need $120,000 to refurbish her house at the comer of a main road into a cake shop in 5 years. She has a saving account which earn 3.47% p.a. compounding quarterly and she is able to deposit $800 into that account at the end of each month for 5 years. a) Will Sue have enough money after 5 years? If not, how much is in short? Show all calculations. (4 marks) b) Even if Sue may not have...
YO16_XL_CH11_GRADER_PS1_HW - Loan Analysis
1.4
Project Description:
Janette Franklin, owner of Frank Solutions, LLC, is
considering borrowing $30,000 to finance the renovation of her
office building. She has been given three different loan options
with various terms and interest rates. She knows that she can only
afford to make payments of $530.00 a month and needs your help to
determine which loan option is best.
Instructions:
Step
Instructions
Points Possible
1
Start Excel. Open the file named
e06ch11_grader_h1_Loans.xlsx. Save the...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago