FIN2020 Excel And VBA – Individual Assignment YOU MUST UPLOAD THE EXCEL FILE TO CANVAS BY Deadline: 5:00 PM, Date: Monday 9Th December 2024 Page 2 Of 4 Assignment The Assignment Contains Two Parts. In Part I, You Are Expected To Build A Mortgage Calculator. Part II Requires A More Advanced Trading

FIN2020 Homework 7Prices Of Contingent Claims And Complex Assets:Consider An Economy In Which There Are Two Dates T= 0 And T = 1, And Two Possible States, I= 1 And I=2, At T= 1, Which Occur With Equal Probability, So That M1 == 1/2. In This Economy, Two "Complex" Assets Are Traded. The First Sells F...

FIN2020 HW6 Due: 2024/4/24 5 PM Consider& A& One& Good,& 2 Periods& (T=1,2) Arrow& Debreu& Economy With 2& Investors& Indexed& By I=A, B. There Are 2 States Of& The& World& Indexed& By S=1,2 And They Have Equal& Probability.& The& Agents & Consume & And& Recei...

FIN2020 Homework 5 1.The CAPM And The APT Consider& An& Economy& In& Which& The& Random& Return& R;On& Each& Individual& Asset& I& Is& Determined& By& The& Market& Modelwhere,As & We & Discussed & In & Class,E(Ri)Is & The & Expected& & Return& &

FIN2020& EXERCISE& 31.Consider A Portfolio Of 300 Shares Of Firm A Worth $10/Share And 50 Shares Of Firm B& Worth& $40/Share.You& Expect& A& Return& Of& 8%For& Stock& A& And& A& Return& Of& 13%For& Stock& B.(A)What Is The Total Value Of The Portfolio, What Are The...