Assignments - CAF
MSc Finance - 2018 Assignments
Assignment 1 - Ratio Analysis - Upload your assignment here [ 3 marks]
Assignment 2 - Time Value of Money - Upload Here [ 4 marks]
Assignment 3 - Vlookup Merging - Upload here [ 5 marks]
Assignment 4 - Upload here [ 5 marks]
Old Classes
Assignment 7: Portfolio SD
Req: Find weights that gives us the maximum Sharp Ratio for the portfolio of two assets.
Constraint: The weights should sum to 1
Assignment 6: Vlookup (2 marks)
Step 1 download share prices of at least 5 companies from database
Step 2 download index points data
step 3 merge index points with each company share prices on seperate sheets
Submission due [April 11, 2018]
Assignment 5: Conditional Formatting 10 Examples - 2 marks
Assignment 4 : TVM Exercise [ Download Assignment [ 3 marks, submission deadline = Before Feb 19, 2018]
Upload links:
Assignment 3: Retirement Planning [ 3 marks] [ 3 marks, submission deadline = Before Feb 23, 2018]
I am 25 years old. Next year, I shall get a job and will be saving Rs. 20,000 each month. I shall keep on saving this amount till my retirement, that will happen at age 60. Following are my planning points:
1. At age 30, I shall spend Rs. 500,000 on my marriage
2. At age 40, I shall perform Hajj, Rs. 500,000
3. At age 50, I shall go on a world tour, spending Rs. 1000,000
4. At age, 60 I shall retire and will need Rs. 100,000 each month for the next 20 years
Requirement:
How much should I deposit more today in my account to meet all these expenditures. Rate of return = 12%
Submit in Excel file with proper formating
Solution [ Download ]
Ratio analysis [ 2 marks upload till Feb 14 ]
BS Accounting Finance Group B - Upload here
BS Accounting Finance Group A submit here
Note: Assignments similar in format, content, or any other way will be cancelled.
Assignment 6 - Solver
BS Accounting - Submit Here
MSc Submit Here
Assignment 5 - Cheque Printing - 3 mark
BS Accounting & Finance [ Submit Here]
MSc Fiance [ Submit Here [
Assignment 4 - TAX Calculation with IF - 3 mark
Assignment 3 - Time Value of Money - 3 mark
BBA Accounting & Finance [ Submit Here]
MSc Fiance [ Submit Here [
Assignment 2 - Conditional Formatting - 2 mark
BBa Accounting Students [ Submit Here]
MSc Fiance Students [ Submit Here [
Assignment 2 - Upload Here 2 marks
(i) Make a function that accepts the series of A B C..Z
(ii) Import Data from this file and extract dividend percentages in a separate column
Assignment 3 - Upload Here 5 marks
(i) Ratio Analysis
Assignment 4 - Upload Here 1 marks
(i) Time Value of Money
Assignment 5 - Upload Here 1 marks
(i) Comapny Serial Numbers [Download]
Assignment 6 - Upload Here 2 marks
Select 10 companies from Database, and merge the share prices data of these companies on the basis of data
Assignment 7 - Upload Here 1 marks
Macro use - Copy data 10000 times
ASSIGNMENT No. 3 Automation of Cheque Printing
Download this excel file and complete the following steps.
In the UBL Sheet, you should apply a macro function that does the following:
From the Salary sheet, person names and salary figures are posted to the relevant space of the cheque
Five cheques are printed with the macro in one go while the next applicaton of the macro prints next five cheques.
ASSIGNMENT No. 2 Salary Slip Calculation
Download this excel file and complete the following steps.
1. Complete all the columns for at least 10 person by assuming different salary packages for every person
2. In column M, apply the validation function with options YES and NO
3. Calculate Taxable income in colum N, which should be linked to column M with respect to YES or NO exemption of medical allowance
4. Apply the following tax brackets and rates and find tax in column O:
Less than 600000=0% tax
600001-950000 = 10% tax of the amount exceeding 400000
950001-18,00,000 = Rs. 35000+15% of the amount exceeding 750000
1,800,001-2,900,00 = Rs. 147,500+20% of the amount exceeding 1,500,000
5. Find monthly tax
6. Find monthly salary