Re: homework

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Norman Harker (njharker_at_optusnet.com.au)
Date: 04/02/04


Date: Fri, 2 Apr 2004 23:06:54 +1000

Hi C. Smith!

We don't do homework.

However, the amount at the end of a year is a future value as viewed
at the beginning of the year. You have a rate of interest and a term
of 1 year. The interest is expressed as being "annual interest".

Chip has suggested looking at the PV function.

When completing the homework, don't forget to attribute the help that
you received; attribution will generally be not only acceptable but
can score higher marks.

-- 
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments) 
available free to good homes.
"C. Smith" <cs31504@hotmail.com> wrote in message 
news:LIcbc.31091$u_2.4564@nwrddc01.gnilink.net...
>
> A man goes in the bank and set up an account with a 9.5% annual 
> interest. At the end of the year,  his account has earned $475.00. 
> What was the amount he originally deposit? 


Relevant Pages

  • Re: homework
    ... > We don't do homework. ... the amount at the end of a year is a future value as viewed ... > Excel and Word Function Lists ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Date Format Glitch
    ... (Sales area, date, account name, amount) ... How does Excel handle it upon import? ...
    (microsoft.public.excel.misc)
  • Re: Date Format Glitch
    ... (Sales area, date, account name, amount) ... How does Excel handle it upon import? ...
    (microsoft.public.excel.misc)
  • RE: Pivot Table combine rows with matching ID and SUM amounts
    ... click Insert/Pivot Table then choose the first field (say account) for row ... and 2nd filed (amount) for Values. ... You can then format it as you wish or use the Pivot Table Tools to ... but I have excel 2007 and I can't follow those ...
    (microsoft.public.excel.misc)
  • Re: Paste as Text option is missing...help
    ... I need to be able to take the value 230.00 and paste it into a cell as ... Account Number, Check Number, Amount, Date ... The idea is to export the check run summary to excel - copy ...
    (microsoft.public.excel.misc)