I have an assignment that will be available this coming Saturday Nov 14th around10 or 10:30 AM USA Eastern time ( do not know the exact time because we will have class and then the assignment so can...

Sheet1
    Ans 1    P = NORMSDIST(-.6045 - .7374*.64) = -.9879
            -0.6045
            -0.7374
            0.52
            0.2573696324        25%    Still in recession
    Ans 2    a    (1.0012)2 = (1.0013)1(1+r)1            The one-year rate in one year
            r = .0011 or .11%
        b    (1.0019)3 = (1.0016)2(1+r)1            The one-year rate in two years
            r = .0025 or .25%
        c    More confidence with forecast in one year given less uncertainty
        d    (1.0019)3 = (1.0017)1(1+r)2            The two-year rate in one year
            r...