Borrow 150,000, 30 years, at 9% I have these numbers, not sure if correct: Borrow 150,000...

Borrow 150,000, 30 years, at 9%

I have these numbers, not sure if correct:

Borrow	150,000	mnthly interest	0.0075
years	30	months	360
interest	0.09	pmt	$1,206.93
future sum	187,691

I'm stuck on Sinking Fund factor. I have tried to do this but he wants it done on excel. Can someone please help put me on the right path.

Solutions

Expert Solution

Rahul Sunny answered 4 weeks ago

Next > < Previous

Related Solutions

Consider the following: – You need a $300,000 financing package. – $150,000 at 9%, 30 Years – $100,000 at...

Consider the following: – You need a $300,000 financing package. – $150,000 at 9%, 30 Years – $100,000 at 8%, 20 Years – $50,000 at 7% 10 Years What is the monthly payment for each part of the financing package? What is the IRR on the $300,000 borrowed? Does anybody know how to solve these two questions with details?

Not sure I have medical expenses and credits correct Reba Dixon is a fifth-grade school...

**Not sure I have medical expenses and credits correct ** Reba Dixon is a fifth-grade school teacher who earned a salary of $38,300 in 2018. She is 45 years old and has been divorced for four years. She receives $1,260 of alimony payments each month from her former husband (divorced in 2016). Reba also rents out a small apartment building. This year Reba received $50,000 of rental payments from tenants and she incurred $19,500 of expenses associated with the rental....

Suppose you borrow $ 20,000 at a 9% monthly compound, for 5 years. Knowing that 9%...

Suppose you borrow $ 20,000 at a 9% monthly compound, for 5 years. Knowing that 9% represents the market interest rate, the monthly payment cn current dollars It will be $ 415. 17. If the average monthly general inflation rate is expected to be 0.5%, what will be the annual equivalent of monthly payments equal cn constant dollars?

I am not sure if the ones that I did answer were correct and wanted to...

I am not sure if the ones that I did answer were correct and wanted to make sure. Answer the following questions about the anatomy of muscle: Combination of myofilaments lead to formation of ______________________ Myosin is the make-up of the ______thick______________ filament, while actin protein is the make-up of _______thin_____________ filament Plasma membrane of muscles are known as ______sarcolemma_____________________ Sarcolemma dips down into the cell to produce tube like structures known as _____________________ Connective tissue that wraps around multiple...

PLEASE MAKE SURE ALL THE NUMBERS ARE CORRECT. After the success of the company’s first two...

PLEASE MAKE SURE ALL THE NUMBERS ARE CORRECT. After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2018, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2018) follows. No. Account Title Debit Credit 101 Cash $ 39,164 106 Accounts receivable 13,118 126 Computer supplies 2,645 128 Prepaid insurance 1,980 131 Prepaid rent 2,960 163 Office equipment 8,900 164 Accumulated depreciation—Office equipment $ 0 167...

The loan is for $150,000 with a rate of 6% for 30 years payable monthly. Calculate...

The loan is for $150,000 with a rate of 6% for 30 years payable monthly. Calculate the Monthly Payment (MP): Do a monthly Amortization Table for 4 months using the MP: Calculate the Loan Balance (LB) using the formula approach at the end of 4 months.

The loan is for $150,000 with terms 6%, 30 years. The graduation rate is 7.5% and...

The loan is for $150,000 with terms 6%, 30 years. The graduation rate is 7.5% and occurs 3 times. Calculate the Monthly Payments and Loan Balances for years 1-4 by designing an Amortization Table:

I need a NPV calculation. I just want to make sure I got it correct. Initial...

I need a NPV calculation. I just want to make sure I got it correct. Initial Cost at t=0 is $150 rate = 16% growth rate in perpetuity after year 5 at 1.5% Year 1 2 3 4 5 Cash Flow 5 11.4 14 21 28

An ARM is made for $150,000 for 30 years with the following terms: Initial interest rate...

An ARM is made for $150,000 for 30 years with the following terms: Initial interest rate = 3% Index = 1-year Treasuries Payments reset each year Margin = 2 percent Fully amortizing Interest rate cap = 1 percent annually; 3 percent lifetime Estimated forward rates: BOY 2 4.00% BOY 3 5.25% BOY 4 6% BOY 5 6.50% Compute payments and balances for each of the years 1-5.

You borrow $320,000 for 30 years with 3% APR. This is an interest only mortgage for...

You borrow $320,000 for 30 years with 3% APR. This is an interest only mortgage for the first five years. At the end of the five-year period, the mortgage will be fully amortized for the remaining years at 4.5% APR compounded monthly. a. Find your monthly payments for the first five years b. Find the loan balance at the end of five years after making the 60th payment. c. Find the monthly payments for the amortized mortgage for the remaining...

Subjects