Excel Finance Trick #4: PMT function & Balloon payment

I want to confirm that I have calculated this correctly.
Rate: 5%
Term: 5 years
Principal: 1 000 000
Balloon Payment at end of term: 400 000
I have attached a sample file with my calculation.
Thanks in advance

I am trying to set up a spreadsheet to calculate a loan that has a balloon
payment at the end. Is there an excel spreadsheet template that already has
this. I have tried the loan imortization with extra payments but this does
not fit.

I need to write an Excel function that returns best price of a government bond.

The actual handwritten formula is quite complicated, impossible to display
here, and the input values for this formula are-----------------
Accrued days, Number of coupon period days, Days from settlement to next
coupon date, coupon periods per year, number coupon periods between
settlement & redemption, annual yield, discount rate.

annual int rate = 5.75
number of months = 360
principle - 320000
PMT answer = (103,667.97)

This is not correct. Can someone advise correct format for computing this
payment amount. Seesm straight forward.

Hey everyone I am new to programing in Excel and I do not know enough to wright a function that finds variance of a portfolio. This is what i have so far its messy and does not work.

Function VARPORT(Sa,Wa,Sb,Wb,Sc,Wc,Sd,Wd,Se,We)

va=VAR(Sa)
vb=VAR(Sb)
vc=VAR(Sc)
vd=VAR(Sd)
ve=VAR(Se)


cab=Covar(va,vb)
cac=Covar(va,vc)
cad=Covar(va,vd)
cae=Covar(va,ve)
cbc=Covar(vb,vc)
cbd=Covar(vb,vd)
cbe=Covar(vb,ve)
ccd=Covar(vc,vd)
cce=Covar(vc,ve)
cde=Covar(vd,ve)

VAPORT=((Wa^2)*va)+((Wb^2)*vb)+((Wc^2)*vc)+((Wd^2)*vd)+((We^2)*ve)+(2*Wa*Wb*cab)+(2*Wa*Wc*cac)+(2*Wa *Wd*cad)+(2*Wa*We*cae)+(2*Wb*Wc*cbc)+(2*Wb*Wd*cbd)+(2*Wb*We*cbe)+(2*Wc*Wd*ccd)+(2*Wc*We*cce)+(2*Wd*W e*cde)
End Function

The S stands for a list of stock returns.
The W is what percentage of the portfolio is spent on that stock.
The Covar and Var functions are to calculate the variance of each stock and the covariance between the five.
The three letters are C for covariance and then what stock will be looked at.

This is very confusing to me and I know I just made a big mess, can anyone help or point me int he right direction.

Work four summers, starting at age 16

Save the income in a Roth IRA account

Invest it in a simple, low-cost equity portfolio

Simmer slowly for 47 years

Serve ungarnished (and untaxed) at age 67

If your money is invested in common stocks and you achieve the average
compound annual rate on large-capitalization U.S. stocks, 10.7%, your
account will grow to $9,378 at the end of the fourth year. You will be
20 years old. Invested in the same way, with no additional savings, the
account will grow to:
$25,917 by the time you are 30

$71,625 by the time you are 40

$197,943 by the time you are 50

$547,037 by the time you are 60

And $1,114,423 by the time you are 67

is there a function that will give me this answer without using
multiple rows and columns to calculate this.

I have an Excel file we use as an office schedule. It's essentially a
calendar with a tab for each month. When I updated the worksheet for 2006
the file size shot from 246K to 6.25M. Does anone have an idea why?

Thanks!!

Hi,
I think I got this figured but just would like someone to see if I am on the right track:

I want to purchase a new house. I can afford to pay $1,350 a month for house payments. I'm looking at a 30-year loan with a 8% interest rate.

I Used the Payment function and then Goal Seek to determine how much I can afford to pay for the house.

I ended up getting $183,983 as the Pv value (house price). Does that sound right?

Thanks

When using the payment function in Excel, I notice that the result of
my formula is always a negative number. I have seen two different ways
to crrect this:
One is to put a (-) in the Pv (Present Value) field, before clicking
on the cell that holds the present value.
The other is to put a (-) in front of the equation, like this: = -
PMT(A2/12,A3,A1).
They both give me the desired result. But I was wondering which one is
considered the "proper" way to do it? I am considering taking a MOS
test in Excel (down the road) and I can't find any "official" (ie
Microsoft) documentation that lays this out.

If anyone could give me a reference, or your best idea on how this
would be done, I would appreciate it.
Thanks for taking the time...
Don

When entering a formula for a mortgage payment the formula displays a
negative number. How do I get it to display a positive number for the
monthly payment.