# Payment and frequency (PMT) Time in years (n) Interest rate and compound frequency...

#	Payment and frequency (PMT)	Time in years (n)	Interest rate and compound frequency (I/Y)	Present Value (PV)	Future Value (FV)
1.	$380.00 every 6 months	8 years	7% compounded semi-annually	______________	Not Applicable
2	$456.50 per month	5 ¾ years	7 ¼ % compounded monthly	Not Applicable	_______________
3	$____________ per year	25 payments	3 % compounded annually	$20,000	Not Applicable
4	$454.30 per quarter	__________years	7.54 % compounded quarterly	Not Applicable	$24,000
5	$700 every six months	186 months	_______compounded semi-annually	$15,000	Not Applicable
6	$170 every 3 months	9 years and 3 months	9.95% compounded quarterly	Not Applicable	_______________
7	$6,000 monthly	_________years	2.25 % compounded monthly	$260,000	Not Applicable
8	$ ___________ Per year	27 years	19% compounded annually		$1,000,000

Expert Solution

jeff jeffy answered 1 year ago

loan amount - 1,200,000. terms(years) - 15 interest rate - 3.125% payment frequency - monthly Amortizing...

loan amount - 1,200,000. terms(years) - 15 interest rate - 3.125% payment frequency - monthly Amortizing Loan Assignment

Amortizing Loan Assignment Excels: Loan Amount Term (years) Interest Rate Payment Frequency Punam Barua $500,000 25...

Amortizing Loan Assignment Excels: Loan Amount Term (years) Interest Rate Payment Frequency Punam Barua $500,000 25 3.50% monthly Militza Bodesinsky $9,500 3 25.00% monthly Rob Boucher $350,000 20 3.00% monthly Janice Coleman $1,000,000 15 2.50% monthly Sadiera Crawford $6,500 3 30.50% monthly Delitzel Cruz $750,000 20 4.00% monthly Eroldy Duverge $25,000 5 6.25% monthly Arlene Flores-Icaza $400,000 30 5.25% monthly John Gurcak $35,000 6 6.75% monthly George Juzdan $800,000 30 3.65% monthly Amani Katerji $10,000 3 30.00% monthly Shanay Leary...

Loan amount- 1,200,000 Term(years)- 15% Interest rate- 3.125% Payment frequency- monthly can anyone please solve this...

Loan amount- 1,200,000 Term(years)- 15% Interest rate- 3.125% Payment frequency- monthly can anyone please solve this in excel with formulas for each cells.

There are five time value of money components – FV, PV, N, I, and PMT. Briefly...

There are five time value of money components – FV, PV, N, I, and PMT. Briefly describe each and create a hypothetical and realistic calculation word problem to find one of the components

If $300 is invested at a 4% interest rate for 4 years. How muchmore compound...

If $300 is invested at a 4% interest rate for 4 years. How much more compound interest is earned vs. simple interest (in other words, what was the interest on interest)?(Round to the nearest cent and do not enter the dollar sign)Find the future value of the following cash flow:$10 in 4 years at 5%(Round to the nearest cent and do not enter the dollar sign

Develop the payment table for a balloon payment loan $125,000 loan, 10 years, 10% interest rate,...

Develop the payment table for a balloon payment loan $125,000 loan, 10 years, 10% interest rate, balloon payment of $100,000 Year Total Payment Interest Paid Principal Paid Principal Remaining Balloon

Payment Years Interest Rate (Annual) Future Value (Payment made on last day of period) Future Value...

Payment Years Interest Rate (Annual) Future Value (Payment made on last day of period) Future Value (Payment made on first day of period) $283 15 15 % 6,155 10 12 76,084 7 14 168,932 11 5 Compute the future values of the following annuities first assuming that payments are made on the last day of the period and then assuming payments are made on the first day of the period: (Do not round intermediate calculations. Round your answers to 2...

Coupon Rate as mentioned is 8.750% Payment Frequency is Semi Annually meaning payment to be done...

Coupon Rate as mentioned is 8.750% Payment Frequency is Semi Annually meaning payment to be done two times in a year. Offering Date is 01/05/1983 Maturity Date is 01/15/2023 Offering Price is $99.45 FV = 100 Trading Price = 105.06 A. Using the offering price found in step 3 and assuming the FV = 100 what is the YTM of your bond on offering (This means compute the YTM as if today was the offering date, show all work). B....

Use properties of rational exponents to solve the compound interest formula for the interest rate, r. For the following exercises, use the compound interest formula, A(t) = P(1 + r/n)nt.

For the following exercises, use the compound interest formula, A(t) = P(1 + r/n)nt.Use properties of rational exponents to solve the compound interest formula for the interest rate, r.

Calculate the balloon payment after 5 years on a $100,000 loan with an 10% interest rate,...

Calculate the balloon payment after 5 years on a $100,000 loan with an 10% interest rate, a 20-year amortization and monthly payments of $965.02

Question