Scribd Logo
Upload

Welcome to Scribd!

  • 2 views

    AakashWani_230097

    Uploaded by

    ricksonyonah24

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    AakashWani_230097

    Uploaded by

    ricksonyonah24
    2 views10 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    2 views10 pages

    AakashWani_230097

    Uploaded by

    ricksonyonah24

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 10

    FSDA - Duration- 1 Hour, maximum marks- 40 marks, each question is for 10 marks each.

    Rename and save the file on desktop


    File naming convention- Your name and your roll number
    attempt all the four question and answer in the cell highlighted with yellow color
    Question-1

    ASSET 1,000,000.0
    LIFE 5
    Salvage value 200,000
    WDV rate 27.52%
    make Dep schedule if company uses SLM and tax autority uses WDV
    Actual Bad debts in the 4th year Rs 18000
    Company Books SLM
    ₹ 1.00 ₹ 2.00
    Revenue ₹ 3,000,000.00 ₹ 3,000,000.00
    Cost- 30% ₹ 900,000.00 ₹ 900,000.00
    Provision for Doubtful debts ₹ 6,000.00 ₹ 6,000.00
    EBITDA ₹ 2,094,000.00 ₹ 2,094,000.00
    Dep ₹ 160,000.00 ₹ 160,000.00
    PBT ₹ 1,934,000.00 ₹ 1,934,000.00
    TAX- 25% ₹ 483,500.00 ₹ 483,500.00
    Deferred Tax
    PAT ₹ 1,450,500.00 ₹ 1,450,500.00
    Mention if it is DTA or DTL DTL DTL
    Amount of DTA or DTL ₹ 27,305.08 ₹ 8,368.53
    ₹ 3.00 ₹ 4.00 ₹ 5.00
    ₹ 3,000,000.00 ₹ 3,000,000.00 ₹ 3,000,000.00
    ₹ 900,000.00 ₹ 900,000.00 ₹ 900,000.00
    ₹ 6,000.00
    ₹ 2,094,000.00 ₹ 2,100,000.00 ₹ 2,100,000.00
    ₹ 160,000.00 ₹ 160,000.00 ₹ 160,000.00
    ₹ 1,934,000.00 ₹ 1,940,000.00 ₹ 1,940,000.00
    ₹ 483,500.00 ₹ 485,000.00 ₹ 485,000.00

    ₹ 1,450,500.00 ₹ 1,455,000.00 ₹ 1,455,000.00


    DTA DTA DTA
    -₹ 5,356.31 -₹ 13,803.79 -₹ 21,013.52
    TAX books- WDV
    ₹ 1.00 ₹ 2.00 ₹ 3.00 ₹ 4.00
    Revenue ₹ 3,000,000.00 ₹ 3,000,000.00 ₹ 3,000,000.00 ₹ 3,000,000.00
    Cost- 30% ₹ 900,000.00 ₹ 900,000.00 ₹ 900,000.00 ₹ 900,000.00
    Provision for Doubtful debts
    EBITDA ₹ 2,100,000.00 ₹ 2,100,000.00 ₹ 2,100,000.00 ₹ 2,100,000.00
    Dep ₹ 275,220.34 ₹ 199,474.10 ₹ 144,574.77 ₹ 104,784.86
    PBT ₹ 1,824,779.66 ₹ 1,900,525.90 ₹ 1,955,425.23 ₹ 1,995,215.14
    TAX- 25% ₹ 456,194.92 ₹ 475,131.47 ₹ 488,856.31 ₹ 498,803.79
    Deferred Tax
    PAT ₹ 1,368,584.75 ₹ 1,425,394.42 ₹ 1,466,568.92 ₹ 1,496,411.36
    ₹ 5.00
    ₹ 3,000,000.00
    ₹ 900,000.00

    ₹ 2,100,000.00
    ₹ 75,945.93
    ₹ 2,024,054.07
    ₹ 506,013.52

    ₹ 1,518,040.55
    Coupon 7.52%
    FV 1000
    Maturity 16-Nov-34
    Interest paid annually
    1. Bonds were issues on 16 Nov 2014 when the rate of interest was 7.20% determine the premium or discount on th
    2.If the bond is selling today at Rs 1250, what would be the yield to the investor. Show your working below

    while entering todays date please be careful and use DD.MM.YYYY

    Date
    16-Nov-14 75.20
    16-Nov-15 75.20
    15-Nov-16 75.20
    15-Nov-17 75.20
    15-Nov-18 75.20
    15-Nov-19 75.20
    14-Nov-20 75.20
    14-Nov-21 75.20
    14-Nov-22 75.20
    14-Nov-23 75.20
    13-Nov-24 75.20
    13-Nov-24 -1250.00
    ermine the premium or discount on the day of issuance of bond. ₹ -248.95
    or. Show your working below 7.97%
    Ans-3
    Age 32
    Retirement age 60
    life after retirement 30
    Discount rate 10%
    Expected rate of return on investment 8%
    Pension will be Rs 5000 for every year of completed service
    Show calcualtion for the three years
    30 29 28
    ₹ 47,134.57 ₹ 47,134.57 ₹ 47,134.57
    Particular Year-1 Year-2 Year-3
    Service Cost ₹ 2,701.21 ₹ 2,971.34 ₹ 3,268.47
    Interest Cost ₹ 270.12 ₹ 594.27

    PBO ₹ 2,701.21 ₹ 5,942.67 ₹ 9,805.41

    Service Cost ₹ 2,701.21 ₹ 2,917.31 ₹ 6,418.08


    Performance Assets ₹ 2,971.34 ₹ 3,268.47

    PBA ₹ 2,701.21 ₹ 5,888.65 ₹ 9,686.55

    Surplus / Deficit ₹ 0.00 ₹ -54.02 ₹ -118.85


    "Company P" plans to acquire 60% stake in "Company S" paying Rs 3000
    Determine the amount of Goodwill and prepare a balance sheet using full consolidation and proprtionate consolidation after i
    Highlight the BS total assets and liabilities as per both the method
    Balance sheet- full consolidation method- after incorpo
    Assets Co. P ($mn) Co. S ($mn) Assets
    Plant 20000 5000 Plant
    Cash 10000 Cash
    Other assets 9000 2000 Other assets
    Total assets 39000 7000 Investment
    Total assets
    Liabilities Liabilities
    Common stock 8000 1000 Common stock
    Retained earnings 7000 1500 Retained earnings
    Shareholders’ equity or net worth 15000 2500 Shareholders’ equity or net worth
    Minority Interest
    Debt (assumed interest free) 5000 3000 Debt (assumed interest free)
    Current liability 19000 1500 Current liability
    Total 39000 7000 Total
    Income statement
    Co. P ($mn) Co. S ($mn)
    Revenues 25000 8000 P
    Expenses 11000 4000 S
    Net income 14000 4000 Net income
    S

    Standalone of Parent After incorporating P&l of the subsequesnt year


    ROE 93.33% 160.00% ROE
    ROCE 70.00% 72.73% ROCE
    ROA 35.90% 57.14% ROA
    NP Margin 56.00% 50.00% NP Margin
    onate consolidation after incorporating P&L number.

    tion method- after incorporating Income statement

    25000
    23400 3000 1500 1500
    11000
    3100
    62500

    31400
    3100
    8000
    20500
    63000

    14000
    2400
    16400
    1600

    e subsequesnt year
    52.23%
    41.62%
    26.24%
    49.70%
    Balance sheet- proportionate consolidation method- after incorporating Income statement
    Assets
    Plant 23000 60%
    Cash 23400 3000 1500 1500
    Other assets 10200
    Goodwill 1500
    Total assets 58100
    Liabilities
    Common stock
    Retained earnings
    Shareholders’ equity or net worth 31400

    Debt (assumed interest free) 6800


    Current liability 19900
    Total 58100

    60%
    P 14000 29800
    S 2400
    Net income 16400
    S 1600

    After incorporating P&l of the subsequesnt year


    ROE 52.23%
    ROCE 42.93%
    ROA 28.23%
    NP Margin 55.03%

    You might also like