Instructions Draw Cash flow diagrams Set up and solve problem in Excel If a person borrows...
Instructions
Draw Cash flow diagrams
Set up and solve problem in Excel
If a person borrows $8000 from her bank at an interest rate of 12% per year for three years, how much must she repay at that time (end of year 3) if:
a) the interest is compounded annually
b) the interest is compounded quarterly
Suppose the bank wanted three equal repayments at the end of each year; Assume interest is compounded annually. What would the repayment amounts be?
Homework Answers
Request Answer!
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Add Answer to:
Instructions
Draw Cash flow diagrams
Set up and solve problem in Excel
If a person borrows...
can anyone help me out with this? maybe show excel or factor calculator instructions. 1. Joan...
can anyone help me out with this? maybe show excel or factor
calculator instructions.
1. Joan Smith invested $15,000 into an account in First Grand Rapids Bank on July 1, 2005. At that time, the bank was paying a nominal interest rate of 3% a year compounded semi-annually. From January 1, 2011, the bank increased its nominal rate to 4% compounded quarterly on all the accounts. Because of the increase in interest being paid, Joan deposited an additional $5,000 into...
Please read the questions carefully. Please draw the cash flow diagrams and explain the steps that...
Please read the questions carefully. Please draw the cash flow diagrams and explain the steps that you are going to approach to solve the problems then solve the problem. Show the details in solving the problems. Please write legible hand writing, otherwise there is a deduction from your grade 10 points Missing Cash Flow Diagram is deductible points equal to 10% of the total points for each question. Question - 1 A series of equal semiannual cash flows starts with...
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...
Need to know how to solve these. 27. Adam borrows $4,500 a installments. The actual end-of-year...
Need to know how to solve these.
27. Adam borrows $4,500 a installments. The actual end-of-year payment is t 12 percent annually compounded interest to be repaid in four equal annual . A. $1,482 B. $2,641 C. $1,125 D. $ 942 30. What is the rate of return on an investment of S16,278 if year for the next 10 years? A. 3 percent B. 8 percent C. 18 percent the company expects to receive $3,000 per D. 13 percent 34....
can you solve these two, and please show the functions to input into a financial calculator....
can you solve these two, and please show the functions to
input into a financial calculator. Also why is question 31. answer
choice A and not C?
38. Rita borrows $4,500 from the bank at 9 percent annually compounded interest to be repaid in three equal annual installments. The interest paid in the third year is_ A. $405.00 B. $147.00 C. $352.00 D. $277.95 31. Xiao Xin is planning to accumulate $40,000 by the end of 5 years by making...
Please avoid using excel to solve the problem. Thanks! 7) If the corporate tax rate is...
Please avoid using excel to solve the problem. Thanks!
7) If the corporate tax rate is 40% and the individual tax rate is 20% (and these are the only taxes), if a corporation has $50,000 of operating income, what is the after tax income for its owners? The tax rate is 15% between $0-$50,000 and 25% between $50,001-S 100,000. If you earn $60,000, then what is your average and marginal tax rates? A bank has quoted to you a monthly...
12 What is the future worth of P600 deposited at the end of every month for...
12. What is the future worth of P600 deposited at the end of every month for 4 years if the interest rate is 12% compounded quarterly?Ans P36.64113. A young woman 22 years old, has just graduated from college. She accepts a good job and desires to establish her own retirement Fund Ar the end of each year thereafter she plans to deposit P2,000 in a fund at 15% annual interest. How old will she be when the fund has an...
Sue will need $120,000 to refurbish her house at the corner of a main road into...
Sue will need $120,000 to refurbish her house at the corner 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...
Question 1 - Interest & loan Sue will need $120,000 to refurbish her house at the...
Question 1 - Interest & loan Sue will need $120,000 to refurbish her house at the corner 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)...
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 anyone help me out with this? maybe show excel or factor
calculator instructions.
1. Joan Smith invested $15,000 into an account in First Grand Rapids Bank on July 1, 2005. At that time, the bank was paying a nominal interest rate of 3% a year compounded semi-annually. From January 1, 2011, the bank increased its nominal rate to 4% compounded quarterly on all the accounts. Because of the increase in interest being paid, Joan deposited an additional $5,000 into...
Please read the questions carefully. Please draw the cash flow diagrams and explain the steps that you are going to approach to solve the problems then solve the problem. Show the details in solving the problems. Please write legible hand writing, otherwise there is a deduction from your grade 10 points Missing Cash Flow Diagram is deductible points equal to 10% of the total points for each question. Question - 1 A series of equal semiannual cash flows starts with...
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...
Need to know how to solve these.
27. Adam borrows $4,500 a installments. The actual end-of-year payment is t 12 percent annually compounded interest to be repaid in four equal annual . A. $1,482 B. $2,641 C. $1,125 D. $ 942 30. What is the rate of return on an investment of S16,278 if year for the next 10 years? A. 3 percent B. 8 percent C. 18 percent the company expects to receive $3,000 per D. 13 percent 34....
can you solve these two, and please show the functions to
input into a financial calculator. Also why is question 31. answer
choice A and not C?
38. Rita borrows $4,500 from the bank at 9 percent annually compounded interest to be repaid in three equal annual installments. The interest paid in the third year is_ A. $405.00 B. $147.00 C. $352.00 D. $277.95 31. Xiao Xin is planning to accumulate $40,000 by the end of 5 years by making...
Please avoid using excel to solve the problem. Thanks!
7) If the corporate tax rate is 40% and the individual tax rate is 20% (and these are the only taxes), if a corporation has $50,000 of operating income, what is the after tax income for its owners? The tax rate is 15% between $0-$50,000 and 25% between $50,001-S 100,000. If you earn $60,000, then what is your average and marginal tax rates? A bank has quoted to you a monthly...
Sue will need $120,000 to refurbish her house at the corner 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...
Question 1 - Interest & loan Sue will need $120,000 to refurbish her house at the corner 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)...
Most questions answered within 3 hours.
-
An explosion breaks a 20.0-kg object into three parts. The
object is initially moving at a...
asked 29 seconds ago -
Calculate the approximate number of residues of Rubisco, which
is involved in carbon fixation in plants,...
asked 1 hour ago -
Other decisions about scientific claims can have a much broader
impact.ENERGYarrow-10x10.png, environment, health, security - all...
asked 1 hour ago -
I need to write a research paper and work cited about this
topic: The United States...
asked 2 hours ago -
Hello! I was wondering if I could have some help?
If the vapor pressure of carvone...
asked 2 hours ago -
An economist wants to estimate the mean per capita income (in
thousands of dollars) for a...
asked 2 hours ago -
What would be the input/output characteristic of a circuit
obtained by putting two of your 2's-complementers...
asked 2 hours ago -
In Drosophila, the transition from the syncytial blastoderm
stage to the cellular blastoderm stage is a...
asked 3 hours ago -
Project management question:
Name 3 different types of resources (hint: humans are one
type)
asked 3 hours ago -
Consider the following reaction: C 2H 2( g) + 2H 2( g) C 2H 6(
g)...
asked 3 hours ago -
Consider a 1.0 L buffer containing 0.092 mol L-1 HCOOH and 0.100
mol L-1 HCOO-. What...
asked 3 hours ago -
Koch Realty has owned a vacant land with a FMV of
$775,000 and an adjusted basis...
asked 4 hours ago