Homework Answers
The monthly payment is $407 approx that is calculated as follows as per the PMT formula of excel. The excel sheet cannot be uploaded, so screen shot is being added. For any further clarification, pl as in comment box.
Add Answer to:
I need the spreadsheet.
An engineer wanted to celebrate graduating and getting a job by buying...
An engineer wanted to celebrate graduating and getting a job by buying new furniture for $2400....
An engineer wanted to celebrate graduating and getting a job by buying new furniture for $2400. Luckily the store was offering 6-month financing at an interest of 6%/year compounding monthly. Calculate the monthly payment. PLEASE show how to do this on excel!!
Use Excel For example.. I want it looks like that. An engineer wanted to celebrate graduating...
Use
Excel
For example.. I want it looks like that.
An engineer wanted to celebrate graduating and getting a job by buying a new furniture $2400 Luckily the store was offering 6-month financing at an interest of 6%/year compounding monthly. Calculate the monthly payment. 01 cf 150000 -1000 -1000 -1000 -1000 4000 СТ 200000 1500 1500 1500 1500 5500 0 1 2 4 5 npv pv ($535.27) 1,159.39) ($150,535.27) ($201,159.39) I -
hi how do i solve this please explain You are considering buying a new home. You...
hi how do i solve this please explain
You are considering buying a new home. You will need to borrow 350,000 to purchase the home. A mortgage company offers you a 20-year fixed rate at 9% (as an APR with monthly compounding). If you borrow the money from this mortgage company, your monthly payment will be closest to: A. 18,910.72 B. 3,149.04 C. 38,341.27 D. 3,070.42 E, 2,635.35 F. None of the above is correct.
3% Latisha is graduating from Queens College next semester and she just landed a job at...
3% Latisha is graduating from Queens College next semester and she just landed a job at a hospital as a compliance manager. She is excited at the prospect of this new opportunity. She would like to get more organized financially because she believes her new salary will now allow her to move into her own place. She talks to her friend, Brad, who sends her his monthly budget. It is a good place to start. Rent in the Bronx, however,...
Question 1 [4 points]. As a new engineer with a high-paying job, you understand the importance...
Question 1 [4 points]. As a new engineer with a high-paying job, you understand the importance of saving money now for your future. In your first year of work, you done your best to save as much of your monthly salary as possible, however, due to lots of new expense, you have saved very erratically. You've also moved your money into new accounts every few months to take advantage of special promotions and other incentives. The following cash flow diagram...
3% 4% Latisha is graduating from Queens College next semester and she just landed a job...
3% 4% Latisha is graduating from Queens College next semester and she just landed a job at a hospital as a compliance manager. She is excited at the prospect of this new opportunity. She would like to get more organized financially because she believes her new salary will now allow her to move into her own place She talks to her friend, Brad, who sends her his monthly budget. It is a good place to start. Rent in the Bronx,...
Calculate all of the problems in the document below in an Excel spreadsheet or on a...
Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator. Please show your work in order to get credit. For each problem, state the inputs given, what you are being asked to find (the missing input), and then use the Finance function to get the correct answer (if using Excel). 1. If you wish to accumulate $100,000 in 5 years, how much must you deposit today in an account that pays an...
1. (15% Marks) Engineer Jimmy wants to retire in 10 years and would like to have...
1. (15% Marks) Engineer Jimmy wants to retire in 10 years and would like to have 1 million Euros at that time. If the interest rate is expected to be 6% over the next 10 years, what annual amount would he need to save? 2. (15% Marks) Rosalynn has purchased a house with a loan of $550,000. If the loan interest rate is 6%, what will be her annual payments over the life of the 20-year loan? 3. (15% Marks)...
** Please read the bold statement after the question, I have the answers, but I need...
** Please read the bold statement after the question, I have the
answers, but I need to make sure they are correct. Thanks**
#1 Using a spreadsheet application, create an amortization
schedule for a 30 year, fixed rate (4.58%) $200k loan. Answer the
following: what is the monthly payment? how much total interest
will you pay? Print out enough of your spreadsheet to defend your
work and answers.
Assume that you took the loan in #1 and paid your monthly...
6) A mortgage (loan for buying a house) is an ordinary annuity. With a standard 30-year...
6) A mortgage (loan for buying a house) is an ordinary annuity. With a standard 30-year fixed rate loan, the money is borrowed today and paid back monthly for 30 years in a constant amount. In Yolo County the maximum conforming loan amount is $552,000. A conforming loan meets conditions set by government sponsored entities (GSE) called Fannie Mae and Freddie Mac in the US. Conforming loans usually get a lower interest rate because the bank can sell them easily...
Use
Excel
For example.. I want it looks like that.
An engineer wanted to celebrate graduating and getting a job by buying a new furniture $2400 Luckily the store was offering 6-month financing at an interest of 6%/year compounding monthly. Calculate the monthly payment. 01 cf 150000 -1000 -1000 -1000 -1000 4000 СТ 200000 1500 1500 1500 1500 5500 0 1 2 4 5 npv pv ($535.27) 1,159.39) ($150,535.27) ($201,159.39) I -
hi how do i solve this please explain
You are considering buying a new home. You will need to borrow 350,000 to purchase the home. A mortgage company offers you a 20-year fixed rate at 9% (as an APR with monthly compounding). If you borrow the money from this mortgage company, your monthly payment will be closest to: A. 18,910.72 B. 3,149.04 C. 38,341.27 D. 3,070.42 E, 2,635.35 F. None of the above is correct.
3% Latisha is graduating from Queens College next semester and she just landed a job at a hospital as a compliance manager. She is excited at the prospect of this new opportunity. She would like to get more organized financially because she believes her new salary will now allow her to move into her own place. She talks to her friend, Brad, who sends her his monthly budget. It is a good place to start. Rent in the Bronx, however,...
Question 1 [4 points]. As a new engineer with a high-paying job, you understand the importance of saving money now for your future. In your first year of work, you done your best to save as much of your monthly salary as possible, however, due to lots of new expense, you have saved very erratically. You've also moved your money into new accounts every few months to take advantage of special promotions and other incentives. The following cash flow diagram...
3% 4% Latisha is graduating from Queens College next semester and she just landed a job at a hospital as a compliance manager. She is excited at the prospect of this new opportunity. She would like to get more organized financially because she believes her new salary will now allow her to move into her own place She talks to her friend, Brad, who sends her his monthly budget. It is a good place to start. Rent in the Bronx,...
1. (15% Marks) Engineer Jimmy wants to retire in 10 years and would like to have 1 million Euros at that time. If the interest rate is expected to be 6% over the next 10 years, what annual amount would he need to save? 2. (15% Marks) Rosalynn has purchased a house with a loan of $550,000. If the loan interest rate is 6%, what will be her annual payments over the life of the 20-year loan? 3. (15% Marks)...
** Please read the bold statement after the question, I have the
answers, but I need to make sure they are correct. Thanks**
#1 Using a spreadsheet application, create an amortization
schedule for a 30 year, fixed rate (4.58%) $200k loan. Answer the
following: what is the monthly payment? how much total interest
will you pay? Print out enough of your spreadsheet to defend your
work and answers.
Assume that you took the loan in #1 and paid your monthly...
6) A mortgage (loan for buying a house) is an ordinary annuity. With a standard 30-year fixed rate loan, the money is borrowed today and paid back monthly for 30 years in a constant amount. In Yolo County the maximum conforming loan amount is $552,000. A conforming loan meets conditions set by government sponsored entities (GSE) called Fannie Mae and Freddie Mac in the US. Conforming loans usually get a lower interest rate because the bank can sell them easily...
Most questions answered within 3 hours.
-
The area of an elastic circular loop decreases at a constant
rate, dA/dt = −6.60×10−3 m2/s...
asked 11 minutes ago -
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 1 hour ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 1 hour ago -
implement a program that reads a number of rows and a symbol.
The program will draw...
asked 1 hour ago -
Assume that when adults with smartphones are randomly selected,
45% use them in meetings or classes....
asked 1 hour ago -
Determine the number of formula units of
Na2SO4 and moles of oxygen contained in 8.11
moles...
asked 2 hours ago -
Explain in steps on the following code
What would be the output when executed
using System;...
asked 2 hours ago -
Given the information in the table, which of the following
statements is CORRECT?
Stock A
Stock...
asked 2 hours ago -
Write MARIE assembly language programs that do the following:
Write a program that inputs an integer...
asked 2 hours ago -
Explain an understanding of services and protocols.
Explain the job of DNS.
Explain the three email...
asked 2 hours ago -
(As soon as possible) Balance each of the following equations
according to the half-reaction method:
H2O2(aq)...
asked 2 hours ago -
A thin rod with a mass of 3.5kg and a length L=1.5 m is oriented
horizontally....
asked 2 hours ago