Posts: 436765 Topics: 21976 LOGIN

Favourites

Most popular topics | Anything elseopen/close

Latest topics | Anything elseopen/close

 

Searchopen/close

Posts Topics

>> extended Search
 

  POST A NEW TOPIC REPLY  

Home >> Anything else >> Evening everyone

10.11.2006, 22:03 quote

Aradon
Aradon Joined: 10 Aug 2006 Posts: 3097 Location: United Kingdom, England, Suffolk
View user's profile Visit poster's website

ahh AP have you gotten round to um, ****,okay lemme think on this a mo *thnking cap on*......................................................................................................................................................................................................................

Got it!!!!

lookup forumlae LOL

i made one once that was as long as your arm Very Happy

*edited*
Oi, mind your language!
_________________
Please read the forum guidelines before you post

 
Back to Top

10.11.2006, 22:13 quote

elkabong
elkabong Joined: 19 Sep 2006 Posts: 135 Location: United Kingdom, Scotland, Glasgow
View user's profile Visit poster's website

working at 8.30 tomorrow, so watched the borat movie and the strongest drink i had was dr pepper...its friday night this is soooo wrong
_________________
www.myspace.com/saviouk

 
Back to Top

10.11.2006, 22:21 quote

Anonymous

almostpurrrfect wrote:

ya know what ones just warp my mind? i mean totally render me incapable of thinking in anything but bloody gobbledegook for at least a half an hour afterwards...?

=if(D5>=53,009,"Good Year",if(D5<40,000,"Bad Year","Ok"))

yup....those!


Here is part of it below, I posted it on here couple weeks ago, but no one came up with any help. I've answered some of it, and I've got another 2 weeks to finish it so there still time..any help would be nice Mandy Smile



1. Consider the simple present value model described in the lecture:

P = F/(1 + i )n

If F = £1000, I = 12% and n = 6 years then determine the present value P using:
a) Excel, to solve the problem directly, without using any of the built-in financial functions
b) Excel, to solve the problem directly, using Excels built-in financial functions

Construct a table of values for P, on a new worksheet with F varying in steps of £500 from £0 to £10000 and i varying in unit steps from 5% to 15%. (n fixed here at 6 years)

Copy the worksheet to 10 other worksheets and hence create a workbook of present values with F varying in steps of £500 from £0 to £10000, i varying in unit steps from 5% to 15% and n varying in half yearly steps from 1 to 6 years.

You will now have a workbook consisting of 12 sheets; entitle it PRAC2Q1.

2. Consider a more advanced financial model to determine the net present value, P, of an initial investment I, that has end-of-year cash returns Fk at the end of each of m years:

P = S Fk /(1 + i )m - I

Suppose that the initial investment is I = £1000, the interest rate is I = 12%, the project last for m = 10 years and the annual cash return over the 10 years is Fk = {£200, £300, £300, -£100, £200, £250, £300, £400, £400 and £400}.

Model and solve this problem using the methods and models outlined above.
Determine the payback period (year in which the project breaks even, P = 0) and the internal rate of return (the interest rate for which P = 0) for this project.

Entitle the workbook PRAC2Q2.

3. Suppose for question 2 that the end-of-year cash returns are initially £200 and that they increase by 10% per year.

Modify your model in 2. above to solve the problem, and add as an extra sheet to the workbook.

What if the increase in end-of-year cash flows changes from 10% to 8% per year?
Modify your model to solve the problem, and add as an extra sheet to the workbook.

If we were seeking a net present value of £800 what initial cash return would be required in order to achieve this goal? (using the end-of-year cash returns increase by 10% per year). Hint – use goal seeking in Excel. Add this analysis as an extra sheet in your workbook. (It should now consist of 4 sheets)

 
Back to Top

10.11.2006, 22:38 quote

Aradon
Aradon Joined: 10 Aug 2006 Posts: 3097 Location: United Kingdom, England, Suffolk
View user's profile Visit poster's website

jeg mate thats way over th top lol ap's formula merely states if d5 is less thn or equal to a certin number its a good year if its over a certain number then its a bad year, else its ok LOL
_________________
Please read the forum guidelines before you post

 
Back to Top

11.11.2006, 11:04 quote

Anonymous

jeggea i'll have an answer for you on monday lol. i'll ask my co-ordinator to help cos that is one long ass formula that would just wreck my head.

 
Back to Top

11.11.2006, 15:07 quote

Anonymous

almostpurrrfect wrote:
jeggea i'll have an answer for you on monday lol. i'll ask my co-ordinator to help cos that is one long ass formula that would just wreck my head.


Thanks Mandy....that will be a great help if you could get any kind of result. Smile

 
Back to Top

11.11.2006, 15:11 quote

Anonymous

Aradon wrote:
jeg mate thats way over th top lol ap's formula merely states if d5 is less thn or equal to a certin number its a good year if its over a certain number then its a bad year, else its ok LOL


I know mate...programming is my best subject so I know a bit about conditions and the if statement. Razz

 
Back to Top

11.11.2006, 16:13 quote

Aradon
Aradon Joined: 10 Aug 2006 Posts: 3097 Location: United Kingdom, England, Suffolk
View user's profile Visit poster's website

Jeggea wrote:
Aradon wrote:
jeg mate thats way over th top lol ap's formula merely states if d5 is less thn or equal to a certin number its a good year if its over a certain number then its a bad year, else its ok LOL


I know mate...programming is my best subject so I know a bit about conditions and the if statement. Razz


yarr didnt realise you were posting your own problem, in my semi drunken state i thought it was a solution to hers but sure and thats one hell of a scenario youve got yourself there Very Happy

ive worked out P but to tell would be CHEATIN

shame on you LMAO
_________________
Please read the forum guidelines before you post

 
Back to Top

12.11.2006, 06:48 quote

Anonymous

Aradon wrote:
Jeggea wrote:
Aradon wrote:
jeg mate thats way over th top lol ap's formula merely states if d5 is less thn or equal to a certin number its a good year if its over a certain number then its a bad year, else its ok LOL


I know mate...programming is my best subject so I know a bit about conditions and the if statement. Razz


yarr didnt realise you were posting your own problem, in my semi drunken state i thought it was a solution to hers but sure and thats one hell of a scenario youve got yourself there Very Happy

ive worked out P but to tell would be CHEATIN

shame on you LMAO


Not really cheating because you have to find these things out one way or another..if I went to a lecturer and told I was having problems, he would probably help me with it. I picked the wrong module here [I should have done 'managing networks' instead], I know the basics of excel...but this is all a bit extreme for me. I've made a start, just have to get my head down. Surprised

 
Back to Top
  POST A NEW TOPIC REPLY  
 
Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum