#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default S Curves

I am trying to do a project where I calculate the net present value of brand earnings as determined.

To do this, I need to calculate a discount value which I know how to calculate it conceptually but not actually.

I have to calculate an S curve using a subjectively derived brand risk index score (a number between 1 and 100 where 100 is the lowest risk and 1 the highest)This established the brand risk profile which is inversely related to the cost of capital (high risk profile has a low cost of capital, a low profile a high cost). I know the lowest cost of capital is about 5% (risk free) and the average wieghted cost of capital (for an industry) but I dont know the highest cost...( I could guess at the max however).

Can anyone help me out!!!



Only thing is, I am not sure how to calculate it.


Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET DropDown ListBox and XML Databinding
http://www.eggheadcafe.com/tutorials...n-listbox.aspx
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 257
Default S Curves

Sounds to me like you're asking an algebra question rather than an Excel
question, Marc; is that right? NPV is easy enough, but only if you can
calculate (well, estimate) the quantity of each of the future earnings.

Why do you say the capital cost varies inversely with the risk? Are you
saying the capital investment is the same regardless, so the capital LOSS (so
to speak) varies with the estimated risk? Because it seems to me that two
investments can have the same probability of failure and yet one require more
capital investment than the other.

If your inputs are only 1) capital investment, 2) risk of failure and 3)
estimated future earnings, period by period, the calculating net earnings
each period should be easy enough if you know how quickly the original
investment should be recouped, and the NPV of the remainder can be calculated
from that. Or am I totally misunderstanding the problem?

--- "Marc Shields" wrote:
I am trying to do a project where I calculate the net present value of brand earnings as determined. To do this, I need to calculate a discount value which I know how to calculate it conceptually but not actually.

I have to calculate an S curve using a subjectively derived brand risk index score (a number between 1 and 100 where 100 is the lowest risk and 1 the highest)This established the brand risk profile which is inversely related to the cost of capital (high risk profile has a low cost of capital, a low profile a high cost). I know the lowest cost of capital is about 5% (risk free) and the average wieghted cost of capital (for an industry) but I dont know the highest cost...( I could guess at the max however).

Only thing is, I am not sure how to calculate it.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default S curves and marketing

Bob,

Thanks for the response. Actually, I am not sure about the calculus part. I have sound statistics but for the rest?.! Let me set this up better for you..

First, the NVP is not the problem for me but thanks for the great explanation?.

Maybe I can explain this better

I will determine value between 1 and 100 for a company?s marketing program risk..

This is determined subjectively through expert research?

The hard part?.

I want to use the S curve to calculate a ?precise? cost of capital or rather

We know that cost of capital is inversely related to risk

We know the risk free cost and the average cost of capital (and I can guess the highest cost)

What I want to see the theoretical relative cost of capital between marketing plan risk.

To do this, other marketing experts have converted the INDEX SCORE and the Cost of Capital to an S curve to show the relative risk to each marketing plan.

Is this better?

Sincerly greatful for your response!

Marc




Bob Bridges wrote:

Sounds to me like you are asking an algebra question rather than an
22-Jan-10

Sounds to me like you are asking an algebra question rather than an Excel
question, Marc; is that right? NPV is easy enough, but only if you can
calculate (well, estimate) the quantity of each of the future earnings.

Why do you say the capital cost varies inversely with the risk? Are you
saying the capital investment is the same regardless, so the capital LOSS (so
to speak) varies with the estimated risk? Because it seems to me that two
investments can have the same probability of failure and yet one require more
capital investment than the other.

If your inputs are only 1) capital investment, 2) risk of failure and 3)
estimated future earnings, period by period, the calculating net earnings
each period should be easy enough if you know how quickly the original
investment should be recouped, and the NPV of the remainder can be calculated
from that. Or am I totally misunderstanding the problem?

--- "Marc Shields" wrote:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
System.Xml.XmlSerializer Overview
http://www.eggheadcafe.com/tutorials...erializer.aspx
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
Subtracting curves [email protected] Charts and Charting in Excel 6 April 27th 23 03:45 AM
curves PAL Excel Worksheet Functions 2 June 25th 08 08:15 AM
Growth Curves andyfw Excel Discussion (Misc queries) 3 January 1st 08 05:06 PM
Bell Curves Rob Charts and Charting in Excel 2 November 14th 06 10:59 PM
combine 2 curves Ruud Excel Worksheet Functions 1 December 7th 04 03:47 PM


All times are GMT +1. The time now is 07:03 PM.

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

About Us

"It's about Microsoft Excel"