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...
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...
This extended problem covers many of the features of a mortgage. You purchase a town house...
This extended problem covers many of the features of a mortgage. You purchase a town house for $300,000. Since you are able to make a down payment of 20 percent ($60,000), you are able to obtain a $240,000 mortgage loan for 20 years at a 4 percent annual rate of interest. a. What are the annual payments that cover the interest and principal repayment? b. How much of the first payment goes to cover the interest? c. How much of...
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.
-
A 4.75 kg crate is suspended from the end of a short vertical
rope of negligible...
asked 2 minutes ago -
develop an automated invoice generator that helps a shop owner
to design their invoice. Problem 1...
asked 10 minutes ago -
2. Binomial Distribution Suppose I have an unfair coin, it lands
on heads 75% of the...
asked 24 minutes ago -
negotiators with absolutely no alternative to a negotiated
agreement sometimes.
a. become hostile and end the...
asked 23 minutes ago -
Write a Verilog program that tests whether a 4-bit input
variable is a Fibonacci number or...
asked 32 minutes ago -
MYSQL
Consider the sql statement "select * from t1 UNION t2" where t1
and t2 are...
asked 35 minutes ago -
2. A retailer sells 10,000 units at $10. Each unit costs the
retailer $7.00 to sell,...
asked 37 minutes ago -
If the Stratosphere elevator in Las Vegas is 500 m above the
ground when the cables...
asked 50 minutes ago -
identify at least one other characteristics of the soils/sand
that may have impacted the growth of...
asked 56 minutes ago -
True or False
The following statements refer to The Web of Belief
10. An explanation of...
asked 58 minutes ago -
15)___________ A study was conducted to
test the effectiveness of aspirin on reducing
asked 1 hour ago -
How fast must a centrifuge spin if a particle 8 cm from the axis
of rotation...
asked 1 hour ago