Given the following information: Current Market Interest Rate: 6.5% Annual Number of Payments: 2 per Year...
Given the following information:
Current Market Interest Rate: 6.5%
Annual Number of Payments: 2 per Year X 3 years
Annual Coupon Payment: $70
Present Value: -1030
Please find future value using excel.
Homework Answers
Using excel we write the below formula in any cell
=FV(6.5%/2,2*3,70/2,-1030)
=$1,020.07
Add Answer to:
Given the following information:
Current Market Interest Rate: 6.5%
Annual Number of Payments: 2 per Year...
A 7-year annuity has annual payments of $2,500. The first payment is at the end of...
A 7-year annuity has annual payments of $2,500. The first payment is at the end of year 1. If interest is 5 percent per annum (effective annual rate) for 2 years followed by 6 percent per annum (effective annual rate) for 5 years, what is the future value of this annuity at the end of 7 years? Please don't answer using excel.
Using the appropriate present value table and assuming a 2% annual market interest rate, determine the...
Using the appropriate present value table and assuming a 2% annual market interest rate, determine the present value, of a 3 year note with the face value of $5,000, and stated interest rate of 4%, with annual interest payments. Your firm agrees to the lend money to your supplier at the present value of the above note receivable. Write down the journal entries to record the initiation of such a loan at the calculated present value. Step 1: determine the...
Suppose that the market interest rate is 4% and then drops overnight to 2%. Calculate the...
Suppose that the market interest rate is 4% and then drops overnight to 2%. Calculate the present values of the 1.25%, 3-year bond and of the 1.25%, 30-year bond both before and after this change in interest rates. Assume annual coupon payments. Confirm that your answers correspond with Figure 6.5. Use your financial calculator or a spreadsheet. You can find a box on bond pricing using Excel later in this chapter. FIGURE 6.5 Plot of bond prices as a function...
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...
Complete the following table. Annual Number of Payments or Years Interest Rate Future Value Annuity Present...
Complete the following table. Annual Number of Payments or Years Interest Rate Future Value Annuity Present Value $250.00 10 20 25 30 6% 12% 4% 2% $1,000 $500,000 $1,000,000
You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly....
You wish to buy a car for $12,000 at a 5% annual interest rate,
compounded monthly. The loan will be repaid in 5 years with monthly
payments. What is your monthly payment (calculated with the
equations on the next page)? Compare your answer to that obtained
with the built in function, PMT. Be sure to label all cells
appropriately. (There is no need to create a monthly payment table,
simply use the equations on the next page.)
Loans: where: and,...
Help with #4 please be $530 per acre-ft, using an interest rate of 10% per year,...
Help with #4 please
be $530 per acre-ft, using an interest rate of 10% per year, a) Determine the difference between present worth (in $/acre-ft) of the old and the new contracts (solve using both formula and spreadsheet functions). b) If new contract also needs a future payment of $2,000 at year 20, what is the equivalent annual worth of the new contract? (solve using both table values and spreadsheet functions) During a period when the real estate market in...
Kiss the Sky Enterprises has bonds on the market making annual payments, with 9 years to...
Kiss the Sky Enterprises has bonds on the market making annual payments, with 9 years to maturity, and selling for $900. At this price, the bonds yield 8.4 percent. What must the coupon rate be on the bonds? (Note: first find the coupon payment, then the coupon rate. The face value of $1,000 x coupon rate = coupon payment).
What is the present value of a 4-annual payment, $444 per year annuity at an interest...
What is the present value of a 4-annual payment, $444 per year annuity at an interest rate of 4% if the first payment is received at the beginning of year 4? The answer is 1490 but how. no excel with calculator please.
Face Value $500,000 Coupon Rate 5.0% Market Rate 4.0% Semiannual Interest Payments Due June 30 and...
Face Value $500,000 Coupon Rate 5.0% Market Rate 4.0% Semiannual Interest Payments Due June 30 and Dec 31 Maturity Date 5 years Issue Date Jan.1 Based on the data above, complete the journal entries for: The issue of the bonds on January 1 The payment of interest and amortization of the premium on June 30 and the payment of interest and amortization of the premium on December 31 Date General Journal Debit Credit 1/1 6/30 12/31 Face Value $200,000 Coupon...
Suppose that the market interest rate is 4% and then drops overnight to 2%. Calculate the present values of the 1.25%, 3-year bond and of the 1.25%, 30-year bond both before and after this change in interest rates. Assume annual coupon payments. Confirm that your answers correspond with Figure 6.5. Use your financial calculator or a spreadsheet. You can find a box on bond pricing using Excel later in this chapter. FIGURE 6.5 Plot of bond prices as a function...
Complete the following table. Annual Number of Payments or Years Interest Rate Future Value Annuity Present Value $250.00 10 20 25 30 6% 12% 4% 2% $1,000 $500,000 $1,000,000
You wish to buy a car for $12,000 at a 5% annual interest rate,
compounded monthly. The loan will be repaid in 5 years with monthly
payments. What is your monthly payment (calculated with the
equations on the next page)? Compare your answer to that obtained
with the built in function, PMT. Be sure to label all cells
appropriately. (There is no need to create a monthly payment table,
simply use the equations on the next page.)
Loans: where: and,...
Help with #4 please
be $530 per acre-ft, using an interest rate of 10% per year, a) Determine the difference between present worth (in $/acre-ft) of the old and the new contracts (solve using both formula and spreadsheet functions). b) If new contract also needs a future payment of $2,000 at year 20, what is the equivalent annual worth of the new contract? (solve using both table values and spreadsheet functions) During a period when the real estate market in...
Kiss the Sky Enterprises has bonds on the market making annual payments, with 9 years to maturity, and selling for $900. At this price, the bonds yield 8.4 percent. What must the coupon rate be on the bonds? (Note: first find the coupon payment, then the coupon rate. The face value of $1,000 x coupon rate = coupon payment).
Most questions answered within 3 hours.
-
Match the key paradoxes of negotiation.
Claiming Value
Sticking by your principles
Sticking with your strategy...
asked 19 minutes ago -
Question text Suppose a sample of 28 observations is taken from
a population, and the sample...
asked 1 hour ago -
The mayor of a small town estimates that 33% of the
residents in the town favor...
asked 2 hours ago -
1. True or false: According to the Gordon Growth Model, firms
that pay dividends will always...
asked 2 hours ago -
20
Lansing Corporation reported net income of $67 million for last
year. Depreciation expense totaled $15...
asked 3 hours ago -
Write a MATLAB userdefined function that calculates the product and
the ratio of two variables x...
asked 3 hours ago -
Timia needs some cash in a hurry. She owns her car outright and
is considering a...
asked 3 hours ago -
A sweepstakes posted the probabilities of winning each prize and
the prize amounts as shown in...
asked 3 hours ago -
Synthesis of fructose-2,6-bisphosphate is catalyzed by a
bifunctional enzyme that contains two catalytic domains: PFK2
(kinase...
asked 3 hours ago -
observation
initial burst volume
total volume titrated to reach end point
what happened to the rise...
asked 3 hours ago -
Let x1, x2,x3,and x4 be a random sample from
population with normal distribution with mean ?...
asked 3 hours ago -
A string of mass m and length L is under tension T. The speed of
a...
asked 3 hours ago