Education_Input Education Fund Beginning of year InvestmentYears to matureYield at maturity123456789 A10.0611111111 B20.141 1 1 1 C30.181 1 D70.651 12141618Payment...

1 answer below »
Answer in the same excel file


Education_Input Education Fund Beginning of year InvestmentYears to matureYield at maturity123456789 A10.0611111111 B20.141111 C30.1811 D70.651 12141618Payment needed ($K) Answers to the questions: [You should summarize your answers to the question here] Formulate an LP model to help Lisa make the decision. Use the spreadsheet provided to execute the model in Excel.
Answered 4 days AfterJun 05, 2022

Answer To: Education_Input Education Fund Beginning of year InvestmentYears to matureYield at...

Rochak answered on Jun 10 2022
84 Votes
Education_Input
    Education Fund
                    Beginning of year
    Investment    Years to mature    Yield at matur
ity    1    2    3    4    5    6    7    8    9
    A    1    0.06    1    1    1    1    1    1    1    1
    B    2    0.14    1        1        1        1
    C    3    0.18    1            1
    D    7    0.65    1
                                    12    14    16    18    Payment needed ($K)
    Solution
        A1    A2    A3    A4    A5    A6    A7    A8    B1    B3    B5    B7    C1    C4    D1    V
    Year 1    1                                1                1        1    -1    0.00    =    - 0
    Year 2    -1.06    1                                                            - 0    =    - 0
    Year 3        -1.06    1                        -1.14    1                            - 0    =    - 0
    Year 4            -1.06    1                                    -1.18    1            - 0    =    - 0
    Year 5                -1.06    1                    -1.14    1                        -0.00    =    - 0
    Year 6                    -1.06    1                                            -12,000.00    =    -12,000.00
    Year 7                        -1.06    1                -1.14    1        -1.18            -14,000.00    =    -14,000.00
    Year 8                            -1.06    1                            -1.65        -16,000.00    =    -16,000.00
    Year...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here