Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 257
Default Calculate Payback Period

G, I must be missing something. If you get paid 50% of your investment
immediately and the other 50% halfway through, then surely you have your
total investment back after term/2 days. That of course is 'way too simple
to need to ask about.

The next most likely scenario I can think of is this: You're investing 50%
of <amt up front, and someone starts making regular payments back to you,
once a period for <n periods. Halfway through the agreed number of periods
you invest the other 50% of your agreed investment. You're asking how to
calculate <n. But that doesn't work either, for any calculation like that
includes interest, and you didn't mention it.

So can you rephrase the question?

--- "G" wrote:
I am trying to figure out how to count the number of days it takes to get
paid back the investment that was paid 50% upfront and 50% midway through
the term of the deal.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
payback period for a 10 years investment tlgoh Excel Worksheet Functions 1 August 25th 08 03:34 PM
payback period Kake Excel Worksheet Functions 2 May 19th 07 07:21 AM
Payback Period rk0909 Excel Discussion (Misc queries) 1 April 12th 07 04:27 PM
Payback Period Plum Excel Discussion (Misc queries) 1 October 21st 06 10:25 AM
How to create data tables and is there a payback period function Austen T Excel Worksheet Functions 0 July 18th 06 05:08 PM


All times are GMT +1. The time now is 08:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"