Homework Answers
Add Answer to:
Can you show me the solutuon by using Excel sheet and Excel
formula!?
5. Assume you...
aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is...
aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is 3%, and you must amortize the loan over 10 years with equal end-of-year payments. A. Calculate the mortgage payment using the Excel function Rate Nper PV FV Payment B. Set up an amortization schedule that shows the annual payments and the amount of each payment that repays the principal and the amount that constitutes interest expense to the borrower and interest income to the...
How to solve this problem by using Excel sheet ans Excel Formula? Congratulations, you are a...
How to solve this problem by using Excel sheet ans Excel
Formula?
Congratulations, you are a lottery winner. As a result, you will receive $3.500 a month for the next 15 years. The first payment is one month from today. Assume that the annual interest rate is 6%. A firm approaches you and is willing to give you $600.000 now if you sign over the lottery winnings to the firm. Is this a good deal? Make sure you show your...
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...
PLEASE DO IN EXCEL AND POST A PICTURE OF THE SHEET Problem #3: Create a table...
PLEASE DO IN EXCEL AND POST A PICTURE OF THE SHEET
Problem #3: Create a table showing the payment of a mortgage of $138,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 9.95% (a) What is the monthly payment? (b) What is the interest paid at the...
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...
Can you please solve this and show the steps Im using a financial calculator, so please...
Can you please solve this and show the steps
Im using a financial calculator, so please list the inputs.
2. Mr. and Mrs. Spirit purchased a $35,000 house 20 years ago. They took a 30-year mortgage for $30,000 at a 3% annual interest rate. Their bank, the First Amityville National Bank, has recently offered the Spirits two alternatives by which they could prepay their mortgage. The Spirits have just made their 20th annual payment. [A] Under the first alternative, the...
You just took out a $350,000, 25-year mortgage at a 5-year rate of 5% from Royal...
You just took out a $350,000, 25-year mortgage at a 5-year rate of 5% from Royal Bank. You will make monthly payments. Assume that the mortgage rate remains at 5% for the remaining time of the mortgage. What is your monthly mortgage payment? What are the principal and interest payments for the 200th monthly payment?
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...
Can you please solve these on Excel and show me how you solved it. Thank you...
Can you please solve these on Excel and show me how you solved
it. Thank you so much.
6) You would like to have $5 million dollars when you retire at age 65. You are 25 years old and you want to make your first savings payment immediately. You have not saved any money for your retirement as of yet. Assume interest rate is 7%, how much money must you set aside per year until and including your 65th birthday?...
1. You have purchased a home for $150,000. Fortunately, you were able to make a down...
1. You have purchased a home for $150,000. Fortunately, you were able to make a down payment of $15,000, but took out a 30-year mortgage for the $135,000 balance. The note payments are $1,388.63 per month at 12% annual interest. A. Prepare the amortization schedule for the first 12 months of payments. B. Calculate the subtotal for the amounts of cash payments, interest payments, and principal payments for the first12 months of payments. C. Calculate the total...
How to solve this problem by using Excel sheet ans Excel
Formula?
Congratulations, you are a lottery winner. As a result, you will receive $3.500 a month for the next 15 years. The first payment is one month from today. Assume that the annual interest rate is 6%. A firm approaches you and is willing to give you $600.000 now if you sign over the lottery winnings to the firm. Is this a good deal? Make sure you show your...
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...
PLEASE DO IN EXCEL AND POST A PICTURE OF THE SHEET
Problem #3: Create a table showing the payment of a mortgage of $138,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 9.95% (a) What is the monthly payment? (b) What is the interest paid at the...
Can you please solve this and show the steps
Im using a financial calculator, so please list the inputs.
2. Mr. and Mrs. Spirit purchased a $35,000 house 20 years ago. They took a 30-year mortgage for $30,000 at a 3% annual interest rate. Their bank, the First Amityville National Bank, has recently offered the Spirits two alternatives by which they could prepay their mortgage. The Spirits have just made their 20th annual payment. [A] Under the first alternative, the...
Can you please solve these on Excel and show me how you solved
it. Thank you so much.
6) You would like to have $5 million dollars when you retire at age 65. You are 25 years old and you want to make your first savings payment immediately. You have not saved any money for your retirement as of yet. Assume interest rate is 7%, how much money must you set aside per year until and including your 65th birthday?...
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