Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
Prepare cash flow statement for the following Balance sheet as on 31st March
Liabilities20042005Assets20042005Share capital100000110000Land and building6000060000Profit and loss a/c Loans2000023000Plant and machinery3500045000Loans-1000stock2000025000Creditors1500018000Debtors1800028000Bills payable50004000Bills receivable20001000Cash500060001400001650005000165000SOLUTIONThe solution is as follows −InflowRs.OutflowRs.Balance b/d5000Purchase of plant10000Issued share capital10000Increase current AssetsLoan10000StockCash opening profit3000Decrease in bills payable5000Decrease in bills1000Balance c/d10000Receivable30001000Increase in creditors60003200032000
Read MoreAnalyse the below table and prepare a common size balance sheet (one of the techniques used in financial statement analysis)
Liabilities2003 (Rs)2004 (Rs.)Assets2003 (Rs.)2004 (Rs.)Capital54825482Cash and balance with RBI67058025543697Reserve and surplus69963008406754Balance with banks and money at call short notice37816115349090Deposits7354078879299033Investments4226011046435410Borrowings672177262960Advances5794769962502390other liabilities and provisions15147661632769Fixed assets369499401240Other assets408108640325228272951389606998115145807124264349solutionThe solution is as follows−PARTICULARS2003 (Rs.)Percentage2004 (Rs.)PercentageAssetsTotal current assetsCash and balance with RBI67058025.8255436974.46Balance with banks and money at call and short notice37816113.2853490904.30Total current assets104874139.10108927878.86Fixed assetsInvestments4226011036.704643541037.37Advances5794769950.336250239050.29Fixed Assets36949900.324012400.32Other Assets408108603.5540325223.25Total Fixed Assets10465839490.9011337156291.23Total Assets (TA)115145807100.00124264349100.0Current liabilitiesBorrowings6721770.812629600.29Other liabilities and provisions15147661.8316327691.82Total Current Liabilities21869432.6418957292.11Fixed liability capital54820.00754820.006Reserves surplus69963008.4684067549.38Deposits7354078888.897929903388.50Total Fixed Liabilities8054257097.368771126997.89Total liability82729513100.0089606998100.00
Read MorePrepare a schedule of changes in working capital and statements of funds of flownBalance sheet as on 31st March
Liabilities20042005Assets20042005Share capital150000180000Land and building8500085000Profit and loss a/c Loans3500042000Plant and machinery5400070000Loans200015000stock3050050000Creditors1700023000Debtors2550045000Bills payable30001000Bills receivable50002000Cash70009000207000261000207000261000SOLUTIONThe solution is as follows − Working capital= current assets – current liabilitiesChanges in working capitalParticulars2004 (Rs.)2005 (Rs.)Incharge (Rs.)Decharge (Rs.)Current AssetsStock305005000019500Debtors255004500019500Bills Receivable500010002000Cash700090002000Total (X)68000106000Current liabilitiesCreditors17000230006000Bills payable300010002000Total (Y)2000024000430008000X-Y480008200035000Increase in W.C.34000340004300043000FUNDS FLOW STATEMENTSourceRs.ApplicationRs.Issued share capital30000Purchase of plant and machinery16000Loan13000Increase in working capital34000Funds from operations70005000050000Funds from operations = 42000-35000 = 7000 (profit and loss a/c)Increase in working capital = 82000-48000 = 34000
Read MoreAnalyse the following table and prepare a trend analysis (one of the techniques used in financialnstatement analysis)
YearDepositsAdvancesProfit199929585549782917751301120003834587510115298594580200146005530128007097382252002536681881428825076951620035878649015799280933680200463372248170362901181468SOLUTIONThe solution is as follows −For DepositsMake Base year as 1990 => 29585549 (100%)YearDepositsCTrend percentage (C*100)199929585549(D1)(D1/D1) = 1100200038345875(D2)(D2/D1) = 1.296129.6200146005530(D3)(D3/D1) = 1.555155.5200253668188(D4)(D4/D1) = 1.814181.4200358786490(D5)(D5/D1) = 1.987198.7200463372248(D6)(D6/D1) = 2.142214.2For Advances − Make Base year as 1990 => 7829177 (100%)YearAdvancesCTrend percentage (C*100)19997829177 (A1)(A1/A1)=1100200010115298 (A2)(A2/A1)= 1.292129.2200112800709 (A3)(A3/A1)= 1.635163.5200214288250 (A4)(A4/A1)= 1.825182.5200315799280 (A5)(A5/A1)= 2.018201.8200417036290 (A6)(A6/A1)= 2.176217.6For profits − Make base year as 1990 => 513011 (100%)YearProfitsCTrend percentage (C*100)1999513011 (P1)(P1/P1)= 11002000594580 (P2)(P2/P1)= 1.159115.92001738225 (P3)(P3/P1)= 1.439143.92002769516 (P4)(P4/P1)= 1.500150.02003933680 (P5)(P5/P1)= 1.820182.020041181468 (P6)(P6/P1)= 2.303230.3
Read MoreHow to prepare comparative balance sheet?
Liabilities2003 (Rs.)2004 (Rs.)Assets2003 (Rs.)2004 (Rs.)Capital54825482Cash and balance with RBI67058025543697Reserve and surplus69963008406754Balance with banks and money at call short notice37816115349090Deposits7354078879299033Investments4226011046435410Borrowings672177262960Advances5794769962502390Other liabilities and provisions15147661632769Fixed assets369499401240Other assets408108640325228272951389606998115145807124264349SOLUTIONThe solution is as follows −ParticularsYear ending 31st marchIncreased/ DecreasedIncreased/ Decreased (%)2003 (Rs.)2004 (Rs.)Amount (Rs)Amount (Rs)AssetsTotal current assetsABA-B=C(C/A)*100Cash and balance with RBI670580255436971162410517.33Balance with banks and money at call and short notice37816115349090-1567479-41.45Total current assets10487413 (X)10892787 (Y)405374 (Y-X=Z)3.86 (Z/X*100)Fixed assetsAB(A-B=C)(A-B=C)Investments4226011046435410-4175300-9.88Advances5794769957947699-4554691-7.86Fixed Assets369499401240-31741-8.59Other Assets408108640325224856411.90Total Fixed Assets104658394 (X’)113371562 (Y’)8713168 (Y’-X’=Z’)8.33 (Z’/X’*100)Total Assets115145807 (x+x’)124264349 (y+y’)91185427.92Current liabilitiesABA-B=C(C/A)*100Borrowings67217726296040921760.88Other liabilities and provisions15147661632769-1180037.79Total Current Liabilities2186943 (X)1895729(Y)29121413.32ABB-A=C(C/A)*100Fixed liability capital54825482--------------------------------------------Reserves surplus69963008406754141045420.16Deposits735407887929903357582457.83Total Fixed Liabilities80542570 (X’)87711269 (Y’)71686998.90X+X’Y+Y’(Y+Y’)-(X+X’)=C’(C’/(X+X’))*100Total liability827295138960699868774858.31
Read MoreHow to find the number of days and number of weeks between two dates in R?
In data analysis, time series is one of the common data we have to deal with and it might also contain dates data along with other variables. We might want to find the difference between two times to check how many days or weeks have changed the time series. This can be easily done with the help of difftime function.Example> difftime(strptime("25/07/2021", format = "%d/%m/%Y"), + strptime("25/07/2020", format = "%d/%m/%Y"), units="weeks") Time difference of 52.14286 weeks > difftime(strptime("25.07.2021", format = "%d.%m.%Y"), + strptime("25.07.2020", format = "%d.%m.%Y"), units="weeks") Time difference of 52.14286 weeks > difftime(strptime("25.07.2021", format = "%d.%m.%Y"), + strptime("25.07.2020", format = ...
Read MoreHow to extract the regression coefficients, standard error of coefficients, t scores, and p-values from a regression model in R?
Regression analysis output in R gives us so many values but if we believe that our model is good enough, we might want to extract only coefficients, standard errors, and t-scores or p-values because these are the values that ultimately matters, specifically the coefficients as they help us to interpret the model. We can extract these values from the regression model summary with delta $ operator.ExampleConsider the below data −> set.seed(99) > x1 x2 x3 x4 x5 x6 x7 y Regression_Model summary(Regression_Model) Call: lm(formula = y ~ x1 + x2 + x3 + x4 + x5 + x6 + x7) ...
Read MoreHow to create a new column with a subset of row sums in an R data frame?
In data analysis, there are many situations we have to deal with and one of them is creating a new column that has the row sums of only some rows. These sums will be repeated so that we get the total number of values equal to the number of rows in the data frame. We can use rowSums with rep function to create such type of columns.ExampleConsider the below data frame −> set.seed(99) > x1 x2 x3 x4 x5 df df x1 x2 x3 x4 x5 1 0.7139625 4 9.321058 0.33297863 4 2 0.9796581 2 4.298837 -1.47926432 11 3 0.5878287 ...
Read MoreHow to deal with error "undefined columns selected when subsetting data frame" in R?
The error “undefined columns selected when subsetting data frame” means that R does not understand the column that you want to use while subsetting the data frame. Generally, this happens when we forget to use comma while subsetting with single square brackets.ExampleConsider the below data frame −> set.seed(99) > x1 x2 x3 x4 x5 df df x1 x2 x3 x4 x5 1 0.7139625 4 9.321058 0.33297863 4 2 0.9796581 2 4.298837 -1.47926432 11 3 0.5878287 3 7.389898 -0.07847958 5 4 0.9438585 4 7.873764 -1.35241100 6 5 0.1371621 2 5.534758 -1.17969925 4 6 0.6226740 4 8.786676 -1.15705659 5 7 -0.3638452 1 ...
Read MoreHow to combine lists in R?
When we have multiple lists but they have similar type of data then we might want to combine or merge those lists. This will be helpful to use because we can perform the calculations using one list name instead of applying them on multiple ones. We can combine multiple lists with the help of mapply function.ExampleConsider the below lists −> List1 List1 [[1]] [1] "a" "b" "c" "d" "e" [[2]] [1] 1 2 3 4 5 [[3]] [1] 5 4 3 2 1 [[4]] [1] 25 [[5]] ...
Read More