Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 442 Weeks Ago, 5 Days Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Accounting Posted 10 May 2017 My Price 5.00

Dan Boyd is a financial planner trying to determine

Dan Boyd is a financial planner trying to determine how to invest $100,000 for one of his clients. The cash flows for the five investments under consideration are summarized in the following table:

 

For example, if Dan invests $1 in investment A at the beginning of year 1, he will receive $0.45 at the beginning of year 2 and another $1.05 at the beginning of year 3. Alternatively, he can invest $1 in investment B at the beginning of year 2 and receive $1.30 at the beginning of year 4. Entries of “0.00” in the preceding table indicate times when no cash in-flows or out-flows can occur. The minimum required investment for each of the possible investments is $50,000. Also, at the beginning of each year, Dan may also place any or all of the available money in a money market account that is expected to yield 5% per year. How should Dan plan his investments if he wants to maximize the amount of money available to his client at the end of year 4?

a. Formulate an ILP model for this problem.

b. Create a spreadsheet model for this problem and solve it using Solver.

c. What is the optimal solution?

 

Answers

Alpha Geek
(8)
Status NEW Posted 10 May 2017 12:05 PM My Price 5.00

-----------

Attachments

file 1494420593-Answer.docx preview (264 words )
D-----------an -----------Boy-----------d i-----------s a----------- fi-----------nan-----------cia-----------l p-----------lan-----------ner----------- tr-----------yin-----------g t-----------o d-----------ete-----------rmi-----------ne -----------how----------- to----------- in-----------ves-----------t $-----------100-----------,00-----------0 f-----------or -----------one----------- of----------- hi-----------s c-----------lie-----------nts-----------. T-----------he -----------cas-----------h f-----------low-----------s f-----------or -----------the----------- fi-----------ve -----------inv-----------est-----------men-----------ts -----------und-----------er -----------con-----------sid-----------era-----------tio-----------n a-----------re -----------sum-----------mar-----------ize-----------d i-----------n t-----------he -----------fol-----------low-----------ing----------- ta-----------ble-----------: ----------- F-----------or -----------exa-----------mpl-----------e, -----------if -----------Dan----------- in-----------ves-----------ts -----------$1 -----------in -----------inv-----------est-----------men-----------t A----------- at----------- th-----------e b-----------egi-----------nni-----------ng -----------of -----------yea-----------r 1-----------, h-----------e w-----------ill----------- re-----------cei-----------ve -----------$0.-----------45 -----------at -----------the----------- be-----------gin-----------nin-----------g o-----------f y-----------ear----------- 2 -----------and----------- an-----------oth-----------er -----------$1.-----------05 -----------at -----------the----------- be-----------gin-----------nin-----------g o-----------f y-----------ear----------- 3.----------- Al-----------ter-----------nat-----------ive-----------ly,----------- he----------- ca-----------n i-----------nve-----------st -----------$1 -----------in -----------inv-----------est-----------men-----------t B----------- at----------- th-----------e b-----------egi-----------nni-----------ng
Not Rated(0)