-
Looking for HSC notes and resources? Check out our Notes & Resources page
Post your acst std answers here (1 Viewer)
- Thread starter bobby
- Start date
Week 1 Solutions?
not sure if they are right,
the retirement benefit at the end of age 65 would be $256,622
excluding the sum of salaries(celerys?)
and sum of salary would be $1,741,377
am i correct, please upload your answerz.
btw, can some one tell me whether we can purchase the acst151 textbook 2nite, or we'll have to wait till 2moro after 10am.
thanx
edit: there was a small but obvious, and stupid mistake i discovered, and now fixed.
Another amendment.
question, the 3% interest doesn't kick in until 8% of the salary==> ie) the super amount stays in the fund for 1 year? ie) only start x by 1.03 when he/she is 22?
also
if no time for posting, then no time for fun,
not sure if they are right,the retirement benefit at the end of age 65 would be $256,622
excluding the sum of salaries(celerys?)
and sum of salary would be $1,741,377
am i correct, please upload your answerz.
btw, can some one tell me whether we can purchase the acst151 textbook 2nite, or we'll have to wait till 2moro after 10am.
thanx
edit: there was a small but obvious, and stupid mistake i discovered, and now fixed.
Another amendment.
question, the 3% interest doesn't kick in until 8% of the salary==> ie) the super amount stays in the fund for 1 year? ie) only start x by 1.03 when he/she is 22?
u put in the cell reference (e.g> B:3 or something) for the interest rate.
also
the most depressing thing i have heard all year,
if no time for posting, then no time for fun,
Last edited:
-=«MÄLÅÇhïtÊ»=-
Gender: MALE!!!
havent started hw yet
uno the goal seek he did during lecture
for the set cell, you choose the difference, to value, you put 0, but what do you click for 'by changing cell'?
i clicked on 1 of the cell allocated for the interest rate but i dun get 5.44
wat am i click on?
uno the goal seek he did during lecture
for the set cell, you choose the difference, to value, you put 0, but what do you click for 'by changing cell'?
i clicked on 1 of the cell allocated for the interest rate but i dun get 5.44
wat am i click on?
-=«MÄLÅÇhïtÊ»=-
Gender: MALE!!!
does excel have cumulative sum?
it'd be soooo much easier if it did
*dun feel like rearranging to form formula.....preserving brain power*
edit: yay worked out a formula. it was right infrotn of my face. was blind for a few minutes there.
it'd be soooo much easier if it did
*dun feel like rearranging to form formula.....preserving brain power*
edit: yay worked out a formula. it was right infrotn of my face. was blind for a few minutes there.
Last edited:
-=«MÄLÅÇhïtÊ»=-
Gender: MALE!!!
well fellaz
i got $1,741,376.56 as the total income and accumulated retirement fund is $259,438.67
did you guys use spread sheet?
either u used calcs and memory erased small decimals, coz mines very close to byteme's answer. Or we're having some confusion with end and start of years?
my interpretation:
salary wen 21 = 30k*1.01, wen 22 = 30k*1.01*1.01 .....etc
super contribution wen 20=0, 21=0.075*(salary wen 21)
super fund wen 20=0, 21=(super contribution)*1.03
find super contibution until 65 and dats the accumulated fund.
i got $1,741,376.56 as the total income and accumulated retirement fund is $259,438.67
did you guys use spread sheet?
either u used calcs and memory erased small decimals, coz mines very close to byteme's answer. Or we're having some confusion with end and start of years?
my interpretation:
salary wen 21 = 30k*1.01, wen 22 = 30k*1.01*1.01 .....etc
super contribution wen 20=0, 21=0.075*(salary wen 21)
super fund wen 20=0, 21=(super contribution)*1.03
find super contibution until 65 and dats the accumulated fund.
-=«MÄLÅÇhïtÊ»=-
Gender: MALE!!!
aw man, u answered q2 the same way as isaaq and willy
y do u reckon he gets nuffin for super contribution wen he's 21?
i mean look at the salary field
he gets 30k wen he's 20. But technically he's not getting that until end of the yr after he works for the year.
I fink ur using accrual and (another method i cant remember name) mixed up 2gether
*shrugs*
but i dunno how bobby and byteme got their answers if they were using spread sheet
y do u reckon he gets nuffin for super contribution wen he's 21?
i mean look at the salary field
he gets 30k wen he's 20. But technically he's not getting that until end of the yr after he works for the year.
I fink ur using accrual and (another method i cant remember name) mixed up 2gether
*shrugs*
but i dunno how bobby and byteme got their answers if they were using spread sheet
to some extent, answer (using the the *2 below) is 259 188 using excel.Originally posted by ByteMe
i got 259 814 ... some1 agree with me
now, my question is: how much goes into the super fund at the age of 21?
1. 30,000 * 0.075
or
2. 30,300 * 0.075
???????
Bobby:
30300*0.075
remember that John Shepherd said that the guy gets paid all his money on his birthday. I think we can assume that the employer contributes to the super fund the day that the guy gets paid all his cash. Therefore, the day he turns 21, he makes $30300 and $30300*0.075 is put into the fund.
30300*0.075
remember that John Shepherd said that the guy gets paid all his money on his birthday. I think we can assume that the employer contributes to the super fund the day that the guy gets paid all his cash. Therefore, the day he turns 21, he makes $30300 and $30300*0.075 is put into the fund.
re malachite:
I think the only place where Flyin' and I differ to your solution is in the first compounded super. At exactly 21, the compounded super is simply equal to the contribution that year (as he is paid on his birthday, and super is contributed also on his birthday). The compounding process hasn't had time to start.
agree Flyin'?
I think the only place where Flyin' and I differ to your solution is in the first compounded super. At exactly 21, the compounded super is simply equal to the contribution that year (as he is paid on his birthday, and super is contributed also on his birthday). The compounding process hasn't had time to start.
agree Flyin'?
-=«MÄLÅÇhïtÊ»=-
Gender: MALE!!!
ye ino how ur viewing it
but im gonna stick wiv my guns
coz i reckon they had "start of each yr" in brackets for the super contribution for a reason
but im gonna stick wiv my guns
coz i reckon they had "start of each yr" in brackets for the super contribution for a reason
can any one pay the Pollards book through perdisco?????
i tried, and only got a msg saying that the transaction failed, (thank you very much) and its not my fault. Something to do wif da encrypted connection to the Bank.!!!!
WTF
hope the credit card isn't charged!!!!!
and I agree with malachite.
i tried, and only got a msg saying that the transaction failed, (thank you very much) and its not my fault. Something to do wif da encrypted connection to the Bank.!!!!
WTF
hope the credit card isn't charged!!!!!
and I agree with malachite.
-=«MÄLÅÇhïtÊ»=-
Gender: MALE!!!
oooooook
question was ambiguous
good news is dat not all questions in future are gonna be like this
imagine how crap an exam would be if every question was like this and only 1 right method.
a fwend told me dat his tutot said 259k is also right. so we're all right. all that discussion for nuffin
and ti wasnt even marked!
question was ambiguous
good news is dat not all questions in future are gonna be like this
imagine how crap an exam would be if every question was like this and only 1 right method.
a fwend told me dat his tutot said 259k is also right. so we're all right. all that discussion for nuffin
and ti wasnt even marked!
did u want it to be marked?
and support from perdisco emailed me saying that the broken connection for credit card payment is due to a technical hitch, .... it seem eveything is due to a tech ....
so, they gave me a telephone number to ring for manual credit card payment.
02-9281 0669
-=«MÄLÅÇhïtÊ»=-
Gender: MALE!!!
ye?
i paid using credit card last night
transaction approved
receit printed
dunno wta happened wiv urs
=/
edit: ye i wanted it marked. coz i actually bothered to work out alternative manually. coz if its not gonna get marked, im gonna get slacker and slacker in future. And then boom! they decide to mark it and i didnt do it.
i paid using credit card last night
transaction approved
receit printed
dunno wta happened wiv urs
=/
edit: ye i wanted it marked. coz i actually bothered to work out alternative manually. coz if its not gonna get marked, im gonna get slacker and slacker in future. And then boom! they decide to mark it and i didnt do it.
Last edited:
pinkbella
Member
*dances for everyones amusement*
Sorry, thought I might liven up the thread a bit.
Media students rule!!
(Hey, the faculty competition is there, let it thrive!)
Sorry, thought I might liven up the thread a bit.
Media students rule!!
(Hey, the faculty competition is there, let it thrive!)
pinkbella
Member
Yes...but what I lack in numbers, I make up in spirit!Originally posted by flyin'
A slight note - You are outnumbered by 5 to 1!
And dancing!!!
*continues festivities*
Stat171 Solutions Tut-week5 is available
please download the solutions from the link below
http://bad.ozforces.com.au/pub_filez/tut5_sol.zip
Enjoy!!!
keep this to students only please!!!!!(and keep it a secret)
please download the solutions from the link below
http://bad.ozforces.com.au/pub_filez/tut5_sol.zip
Enjoy!!!
keep this to students only please!!!!!(and keep it a secret)