On Jan 25, 2024; Prabhudas Lilladher has a buy call on DCB Bank with a target price of Rs 160. The current market price of DCB Bank Ltd. is Rs 135.7. DCB Bank Ltd., incorporated in the year 1995, is a banking company (having a market cap of Rs 4491.33 Crore). This was the data on January 2024. When we look at the data now (28th April 2024) of DCB Bank in the NSE (National Stock Exchange) website, the number has fallen down. I want to collate, comprehend and interpret as many points as I can about what led to this fall in the DCB Bank. I would request the expert to give me as many pointers as he or she can and explain them in a cohensive and comprehensible manner. I want an answer which is very detailed, technical and professional. And please also put this on an excel file and give me a graphical representation. Also give me the steps so that I can put it in a graph. Please do it!

Use the information provided below to prepare the following for January and February 2023:Debtors Collection Schedule   The following information was provided by Intel Enterprises:1. The bank balance on 31 December 2022 is expected to be R40 000 (unfavourable).2. Credit sales are expected to be as follows:December 2022 January 2023 February 2023R576 000 R540 000 R648 0003. Credit sales usually make up 40% of the total sales. Cash sales make up the balance. Cash customersreceive a 10% discount.4. Credit sales are normally collected as follows:* 30% in the month in which the transaction takes place, and these customers are entitled to a 5% discount.* 65% in the following monthThe rest is usually written off as bad debts.5. Budgeted purchases of inventory are as follows:December 2022 January 2023 February 2023R1 000 000 R800 000 R920 0004.26. Fifty percent (50%) of the purchases are for cash. The remainder is paid in the month after the purchase.7. The monthly salaries amount to R150 000.…

Use the information provided below to prepare the following for January and February 2023:4.1 Debtors Collection Schedule  INFORMATIONThe following information was provided by Intel Enterprises:1. The bank balance on 31 December 2022 is expected to be R40 000 (unfavourable).2. Credit sales are expected to be as follows:December 2022   January 2023           February 2023R576 000               R540 000                       R648 0003. Credit sales usually make up 40% of the total sales. Cash sales make up the balance. Cash customersreceive a 10% discount.4. Credit sales are normally collected as follows:* 30% in the month in which the transaction takes place, and these customers are entitled to a 5% discount.* 65% in the following monthThe rest is usually written off as bad debts.5. Budgeted purchases of inventory are as follows:December 2022   January 2023               February 2023R1 000 000             R800 000                   R920 000 6. Fifty percent (50%) of the purchases are…

You have been asked to analyze First Union Bank. You have only the following information on the bank at year-end 2021: Net income is $210, 000, total debt is $1.8 million, and the bank's debt ratio is 60 percent. What is First Union Bank's ROE for 2021? (Do not round intermediate calculations. Round your percentage answer to 2 decimal places. (e.g., 32.16))

You observe the following quotes for the USD/AUD in the spot market from two banks:Bank of Sydney /Bank of New YorkBid Ask/ Bid Ask0.71711 0.71715 /0.71708 0.71715Do these quotes imply the possibility of earning a profit by using locational arbitrage? If so, calculatethe potential profit if you are able to use AUD 25,000. If not, explain why arbitrage is not possible?(b) You observe the following quotes for the GBP /AUD in the spot market from two banks:Bank of Melbourne/ Bank of LondonBid Ask/ Bid Ask0.5458 0.5459 /0.5514 0.5515Do these quotes imply the possibility of earning a profit by using locational arbitrage? If so, calculatethe potential profit if you are able to use GBP 50,000. If not, explain why arbitrage is not possible?c) You observe the following quotes for the EUR / USD in the spot market from two banks:Deutsche Bank/ Bank of AmericaBid Ask /Bid Ask1.18102 1.18102 /1.18094 1.18100Do these quotes imply the possibility of earning a profit by using locational arbitrage? If…

The UAE Central Bank wants to conduct a matched sale purchase transaction for 20 million AED to be reversed in 15 days. Show the effect of this initial operation and the reverse operation on Central Bank balance sheet and Banking System Balance sheet using T-accounts. (Hint: There should be 4 t-accounts).

INFORMATIONThe following information was provided by Intel Enterprises:1. The bank balance on 31 December 2022 is expected to be R40 000 (unfavourable).2. Credit sales are expected to be as follows:December 2022    January 2023       February 2023R576 000              R540 000             R648 0003. Credit sales usually make up 40% of the total sales. Cash sales make up the balance. Cash customersreceive a 10% discount.4. Credit sales are normally collected as follows:* 30% in the month in which the transaction takes place, and these customers are entitled to a 5% discount.* 65% in the following monthThe rest is usually written off as bad debts.5. Budgeted purchases of inventory are as follows:December 2022     January 2023    February 2023R1 000 000            R800 000            R920 0006. Fifty percent (50%) of the purchases are for cash. The remainder is paid in the month after the purchase.7. The monthly salaries amount to R150 000. Salaries are expected to increase by 9% with…

Chase up is public listed company in Pakistan Stock exchange. A few years back chase up started to build a new store on bosan road multan. Details about the construction of new store in multan city are as follows: Chase up issued unsecured loans on 1 april 2008 amounting $10 million with a nominal interest rate of 6%. These unsecured loans are redeemable at a premium with effective finance cost of 7.5% annually. This loan was particularly obtained to finance the nee building of new chase up store which qualify the requirements of qualifying asset prescribed in IAS-23. Construction of the store commenced on 1 may 2008 and it was completed and ready for use on 28 February 2009. But did not open for trading until 1 april 2008. Required: a) what is the total of finance costs which can be capitalized in respect of chase up new store? b) Rather than take out a loan specifically for the new store chase up could have funded the store from existing borrowing whoch are: i. $50 million ( 10% bank…

The following select financial statement information from Vortex Computing. Compute the accounts receivable turnover ratios and the number of days sales in receivables ratios for 2018 and 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Vortex Computing if industry average for accounts receivable turnover ratio is 4 times and days sales in receivables ratio is 85 days?

еВook Zane Corporation has an inventory conversion period of 90 days, an average collection period of 34 days, and a payables deferral period of 48 days. Assume 365 days in year for your calculations. a. What is the length of the cash conversion cycle? Round your answer to two decimal places. days b. If Zane's annual sales are $3,454,540 and all sales are on credit, what is the investment in accounts receivable? Do not round intermediate calculations. Round your answer to the nearest cent. $ c. How many times per year does Zane turn over its inventory? Assume that the cost of goods sold is 75% of sales. Use sales in the numerator to calculate the turnover ratio. Do not round intermediate calculations. Round your answer to two decimal places.