all answered in microsoft excel thank
you!
Homework Answers
rate positively ..
| PV | -286000 | |||||||
| FV | 0 | |||||||
| PMT | 1242.43 | |||||||
| I | 4.01%/12 | 0.33% | ||||||
| therefore using excel formula "nper" we can compute the required year | ||||||||
| Number of month required = | 439.54 | |||||||
| Therefore answer = | 440 |
Add Answer to:
all answered in microsoft excel thank
you!
Problem #1: For Problems 1 and 2, you can...
all answered in microsoft excel thank you! Problem #3: Create a table showing the payment of...
all answered in microsoft excel thank
you!
Problem #3: Create a table showing the payment of a mortgage of $161,000 month by month. Create columns for: - Time (in years) - Interest (for that month) - Payment (always the same value) - Payment against principal - Remaining Principal The mortgage is to last 32 years, and the nominal interest rate is 4.66% (a) What is the monthly payment? (b) What is the interest paid at the end of the 9th...
PLEASE DO IN EXCEL AND POST A PICTURE OF THE SHEET Problem #2: You have taken...
PLEASE DO IN EXCEL AND POST A PICTURE OF THE SHEET
Problem #2: You have taken a loan of $281,000. You can afford to pay monthly payments of $1964.37. This loan will be repaid in 23 years. What is the nominal annual rate of interest charged on this loan? Problem #2: Answer as a percentage, correct to 2 decimals
Please post with mathematical formulas please, not an excel sheet! 1. Mr. X is repaying a loan by monthly payments of $1...
Please post with mathematical
formulas please, not an excel sheet!
1. Mr. X is repaying a loan by monthly payments of $146.75 at a nominal annual rate of 9% compounded monthly. Immediately after one of the pay- ments is made, when Mr. X has still 50 payments ahead of him, the lender lowers the interest rate to 7.8% nominal annual rate compounded monthly. Mr. X chooses to keep the same monthly payments, except the last payment that is larger than...
Problem #2: You have taken a loan of $172,000. You can afford to pay monthly payments...
Problem #2: You have taken a loan of $172,000. You can afford to pay monthly payments of $1063.02. This loan will be repaid in 19 years. What is the nominal annual rate of interest charged on this loan? Problem #2: 15.87 Answer as a percentage, correct to 2 decimals Just Save Submit Problem #2 for Grading Attempt #3 | Attempt #4 | Attempt #5 Problem #2 Your Answer: Your Mark: Attempt #1 | Attempt #2 16.00 15.87 0/1x 0/1x
should be explain it on excel Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and...
should be explain it on excel
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
Answer all these questions. Thank you! 1. 2. 3. 4. 5. Problem 5.12 (Excel Video) Karen...
Answer all these questions. Thank you!
1.
2.
3.
4.
5.
Problem 5.12 (Excel Video) Karen White is saving to buy a house in five years. She plans to put 20 percent down at that time, and she believes that she will need $29,000 for the down payment. If Karen can invest in a fund that pays 9.40 percent annual interest, compounded quarterly, how much will she have to invest today to have enough money for the down payment? (If...
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. Wha...
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car payments of $500 per month for 4 years...
Please don’t use Excel and do all the parts of the questions. Show your work!!! Problem...
Please don’t use Excel and do all the parts of the questions. Show
your work!!!
Problem 1 Greg borrowed $100,000 to purchase a house. He agreed to repay the loan with equal monthly payments over a 30 year period at a nominal annual rate of 6 percent. a. What would be his monthly payment? b. What is the effective annual interest rate on the loan? c. Consider a closing fees of $2,000 on the loan. If he chooses to finance...
Can you help me solve this problem: Using Microsoft Excel to calculate and analyze the Net...
Can you help me solve this problem: Using Microsoft Excel to calculate and analyze the Net Present Value (NPV), Internal Rate of Return (IRR), Accounting Rate of Return and Payback Period of the following investment. Initial Investment $12,950 Estimated Life 10 years Annual Cash Inflows $3,000 Cost of Capital 12%
Can anyone help me solve these without excel? 1) If Serena invests $10,000 today in a...
Can anyone help me solve these without excel? 1) If Serena invests $10,000 today in a project and receives $7,000 one year from today and $5,000 two years from today in return, what is her annual internal rate of return? You can assume that her effective annual discount rate is 20%. 2) Jamie will buy a $2,000,000 house today. She will make a 20% deposit, and borrow the remaining amount in the form of a mortgage. She will repay the...
all answered in microsoft excel thank
you!
Problem #3: Create a table showing the payment of a mortgage of $161,000 month by month. Create columns for: - Time (in years) - Interest (for that month) - Payment (always the same value) - Payment against principal - Remaining Principal The mortgage is to last 32 years, and the nominal interest rate is 4.66% (a) What is the monthly payment? (b) What is the interest paid at the end of the 9th...
PLEASE DO IN EXCEL AND POST A PICTURE OF THE SHEET
Problem #2: You have taken a loan of $281,000. You can afford to pay monthly payments of $1964.37. This loan will be repaid in 23 years. What is the nominal annual rate of interest charged on this loan? Problem #2: Answer as a percentage, correct to 2 decimals
Please post with mathematical
formulas please, not an excel sheet!
1. Mr. X is repaying a loan by monthly payments of $146.75 at a nominal annual rate of 9% compounded monthly. Immediately after one of the pay- ments is made, when Mr. X has still 50 payments ahead of him, the lender lowers the interest rate to 7.8% nominal annual rate compounded monthly. Mr. X chooses to keep the same monthly payments, except the last payment that is larger than...
Problem #2: You have taken a loan of $172,000. You can afford to pay monthly payments of $1063.02. This loan will be repaid in 19 years. What is the nominal annual rate of interest charged on this loan? Problem #2: 15.87 Answer as a percentage, correct to 2 decimals Just Save Submit Problem #2 for Grading Attempt #3 | Attempt #4 | Attempt #5 Problem #2 Your Answer: Your Mark: Attempt #1 | Attempt #2 16.00 15.87 0/1x 0/1x
should be explain it on excel
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
Answer all these questions. Thank you!
1.
2.
3.
4.
5.
Problem 5.12 (Excel Video) Karen White is saving to buy a house in five years. She plans to put 20 percent down at that time, and she believes that she will need $29,000 for the down payment. If Karen can invest in a fund that pays 9.40 percent annual interest, compounded quarterly, how much will she have to invest today to have enough money for the down payment? (If...
Please don’t use Excel and do all the parts of the questions. Show
your work!!!
Problem 1 Greg borrowed $100,000 to purchase a house. He agreed to repay the loan with equal monthly payments over a 30 year period at a nominal annual rate of 6 percent. a. What would be his monthly payment? b. What is the effective annual interest rate on the loan? c. Consider a closing fees of $2,000 on the loan. If he chooses to finance...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago