Excel Case study
vk4queen
casestudysolutionhint.docxChapter 2 part 1
https://www.youtube.com/watch?v=o1VXOh1qYb8&feature=emb_logo
Chapter 2 part 2
https://www.youtube.com/watch?v=IMNlZSEh6sA&feature=emb_logo
Chapter 3 Hint
https://www.youtube.com/watch?v=U2MZRmvDSgY&feature=emb_logo
Chapter 4 Hint 1
https://www.youtube.com/watch?v=C0w05HlmnS8&feature=emb_logo
Chapter 4 Hint 2
https://www.youtube.com/watch?v=kPXuJwE63mI&feature=emb_logo
Chapter 5 Hint 1
There are many possible variations on the VBA code to calculate the payback period. Below is a VBA program from http://www.vbaexpress.com/kb/getarticle.php?kb_id=252.
Use the link above to answer Chapter 5 Case Study #3.
Function PAYBACK(invest, finflow)
Dim x As Double, v As Double
Dim c As Integer, i As Integer
x = Abs(invest)
i = 1
c = finflow.Count
Do
x = x - v
v = finflow.Cells(i).Value
If x = v Then
PAYBACK = i
Exit Function
ElseIf x < v Then
P = i - 1
Z = x / v
PAYBACK = P + Z
Exit Function
End If
i = i + 1
Loop Until i > c
PAYBACK = "no payback"
End Function
Chapter 5 Hint 2
https://www.youtube.com/watch?v=dSpgC5DSuac&feature=emb_logo
Chapter 6 Hint 1
https://www.youtube.com/watch?v=-i_O6Tc_cek&feature=emb_logo
Chapter 6 Hint 2
https://www.youtube.com/watch?time_continue=7&v=sZoCkHdHqfM&feature=emb_logo
Picture of functions you are expected to use:
