You are a credit analyst of a growing commercial bank and have recently received loan applications from two companies of relatively similar size. Show below are selected financial data for these two applicants at the end of the current year: RED CO BLUE CO. Net credit sales P700,000.00 P650,000.00 Cost of goods sold P500,000.00 P490,000.00 Cash P60,000.00 P20,000.00 Accounts receivable (net) P77,000.00 P60,000.00 Inventory P94,000.00 P180,000.00 Current liabilities P110,000.00 P105,000.00 Assume that the year-end balances for accounts receivable and for inventory approximate the average balances of these items throughout the year. A. Compute the following on BLUE
Q: 7. AHR Company has provided the following data: Inventory and prepaid expenses, P35,000; Current…
A: Assets and liabilities are the two components of the balance sheet. Assets can be long-term or…
Q: ACTIVITY 2014 2015 Horizontal Vertical Analysis Analysis Revenue 1,939,500 1,674,675 1- 7. Cost of…
A: Horizontal analysis is that financial statement analysis under which increase or decrease from…
Q: Depreciation of a factory equipment is treated as ? While depreciation of an automobile used for…
A: Overhead costs all type of indirect costs incurred for manufacture and selling of goods. These can…
Q: 4. PT Prahasta produces products through two departments with cost calculations using the weighted…
A: The total cost of producing a product, including raw materials and operating costs, is detailed in a…
Q: Round your answer to the nearest dollar, such as 12345. (No need to write $ as $ is already in front…
A: calculation of gain or loss on bond DE- recognition are as follows
Q: C4 Company owns 8% of Isolate Inc., P100 par, 140,000 outstanding ordinary shares which was acquired…
A: Equity investment which are designated as fair value through profit or loss are recorded initially…
Q: The main purpose of the auditor's consideration of internal control for a non-SEC client is to A.…
A: Audit of internal control is conducted by auditors to assess its efficiency and effectiveness and…
Q: will be paid by his insurance company if a fire causes $710, 000 in losses? $568, 000 $735, 000…
A: Introduction;- The following basic information as follows under:- Troy's Tire Mart has a…
Q: 1. What amount should be reported as basic EPS for 2022 Problem 19-16 (AICPA Adapted) Strauch…
A: EPS is earning per share is calculated as a profit earned by the company in one year and then…
Q: Accounting involves recording, analyzing and summarising the transactions of an entity to provide…
A: Accounting is the process of recording a business's financial transactions. The accounting process…
Q: The following details were obtained from the accounting records of Civil Construction Consultants at…
A: The process of recording business transactions in the books of accounts for the first time is…
Q: Please can you provide some guidance on the deprciation calcuation?
A: Depreciation Expenses - Depreciation Expenses are the expense incurred on the wear and tear of the…
Q: On December 31, 2021, Sleepy Corporation purchased for P40,000,000 cash all of the outstanding…
A: Goodwill: Goodwill is an intangible asset that is associated with the purchase of one company by…
Q: During the current year, Bashful Company incurred the following costs to develop and produce a…
A: Cost: Cost is explained as the amount or something that is being incurred in monetary terms by an…
Q: Consider the following performance report for Jamie's Department Store for the month of October 2021…
A: Percentage increase in sales from Budget to Actual = (473,000 - 430,000)/430,000 = 10% Percentage…
Q: lationary stat
A: Given in question: Balance on December 31, 2021 Machine Acquired on Cost Accumulated…
Q: Mr. Ramos savings allow her to withdraw 50,000 semi-annually for 11 years starting at the end of 5…
A: Solution Concept This is the problem related to time value of money Present value is calculated by…
Q: Aaron Cousins is a self-employed VAT consultant. Aaron's business, Bruins VAT Consultancy Services,…
A: Self employed person shall usually pay 2 types of national insurance: Class 2 if your profits are…
Q: Selected transactions for Ivanhoe Corporation during September 2018, its first month in business,…
A: Ledger accounts are prepared after journal entries. The journal entries are posted into Ledger…
Q: The primary source of revenue for a wholesaler is Oinvestment income. service fees. O the sale of…
A: The primary source of revenue is the main sources of income generated through main course of…
Q: d AC end on 31 December. Required a) Calculate the hire purchase interest included in the hire…
A: "Since you have asked multiple sub part question we will solve the first three sub part question for…
Q: Stinehelfer Beet Processors, Inc., processes sugar beets in batches. A batch of sugar beets costs…
A: The decision of further processing of joint products is based in incremental analysis. If the…
Q: monthly. Then compute for the
A: Compound interest is used in case of lump-sum money accumulates in the future if interest is charged…
Q: 18. Troy's Tire Mart has a replacement value of $965, 000 and is insured for $588, 000, with an 80%…
A: The coinsurance reimbursement amount is determined by dividing the insured value by the required…
Q: Use the following selected information for Jim Beam Company For the year ended 31st December 2020…
A: Factory overhead is indirect labor and indirect cost involved in operating manufacturing business.…
Q: Question 3 (5%) Inventory data for Hot Buys Company for January 2020 are as follows: January I…
A: The inventory can be valued using various methods as LIFO, FIFO and weighted average method. Using…
Q: D. P1,800,000 The QYU, Inc. has sales of P5 million per year (all credit) and an average collection…
A: The average receivable turnover ratio is calculated as net sales divided by average account…
Q: Another team member who is preparing the Budgeted Balance Sheet for the business for the same…
A: Trade Receivable Trade Receivable is an important part in the liquidity of the business entity which…
Q: de during June are shown below: June 1 Inventory 6000 units @$2.00 per unit 4 Purchases 4500 units…
A: Note: Hi! Thank you for the question, As per the honor code, we are allowed to answer three…
Q: How is the average unit cost (of sold products) calculated at the end of a period, for a retailer?…
A: Average unit cost can be calculated by dividing the total cost of goods sold by the total number of…
Q: Question. A calendar-year taxpayer spends $10,000 in December on a file server and peripherals. The…
A: Straight-line depreciation is the depreciation method for recognizing the carrying amount of a fixed…
Q: Waterway Company uses a periodic inventory system. Details for the inventory account for the month…
A: Ending inventory is the cost of things on hand at the end of the reporting period. For a corporation…
Q: True or False 1. Intangible-purchase goals pertain to abstract goals such as happiness, long life,…
A: The answer is stated below:
Q: Inventories Office Supplies Prepaid Insurance Land Building Machinery & Equipment Furniture and…
A: Introduction: A balance sheet is a statement of a person's or company's financial position. The…
Q: Answer the question based on what you have learned on a legal basis. Facts: You offered to sell your…
A: A perfectly contract is a contract which is formed where there is a valid offer by the offeror and…
Q: Prepare a general journal entry to record the weekly payroll of the firm on June 14, 20X1. (Round…
A: Employees are the assets of the company. It is because of the employees that the company is able to…
Q: ABC Company purchased equipment on May 1, 2021 costing $1,000,000. Its estimated salvage value is…
A: Depreciation is charged on assets. It is a non-cash expense. There are several methods to charge…
Q: Problem #4 At December 31, Beaver Company's records show the following amounts in ending Market…
A: Under LCM METHOD inventory is valued at lower of cost and market value. If there is a loss because…
Q: 18. Troy's Tire Mart has a replacement value of $965, 000 and is insured for $588, 000, with an 80%…
A: Introduction: A loss is defined as an increase in costs above revenues, whether for a single…
Q: The Boone Manufacturing had worked on two jobs, Job 101 and Job 102 last year. estimated…
A: Given that, Estimated fixed overhead = P30,000 Estimated variable overhead = P5 per direct labor…
Q: Peter's Records purchases a new Record-Pressing Machine for $77,000, on the 1st January 2020 The…
A: Depreciation means the amount of expenses written off from the value of fixed assets used in…
Q: Mary Poppins plans to start a company and offers to sell 30,000 ordinary shares at a price of $2 per…
A: The total amount received from investor will include the application money received from 40,000…
Q: Determine the unit contribution margin and contribution margin ratio. Last month, Laredo Company…
A: Formula: Unit contribution margin = Sales price per unit - variable cost per unit
Q: 4. The following investment portfolio of equity securities (all acquired during 2019) accounted for…
A:
Q: Determine the monthly amortization for a 5-year car loan worth P800,000 at a 5.5% interest rate,…
A: Compound interest is used in case of lump-sum money accumulates in the future if interest is charged…
Q: Sure Ako Corporation reported pretax income of P4,500,000 for the year ended December 31, 2022. The…
A: Taxable income can be computed as per the following Pretax Income…
Q: How much should Jaybo Company report as unrealized gain or loss related to the securities in its…
A: Unrealized gain or loss is the unrealized either gain or loss which has been calculated when the…
Q: At December 31, 2022, before any year-end adjustments, Dallis Company's Prepaid Insurance account…
A: The prepaid insurance is the amount of insurance paid in advance but is not due yet.
Q: The cost of a purchased building includes all of the following except closing costs. O real estate…
A: Introduction: The cost of assets is defined as the asset's original purchase price, from which we…
Q: Kevin Company had the following bank reconciliation on June 30: Balance per bank statement, June 30…
A: The bank reconciliation statement is prepared to equate the balances of cash book and passbook with…
Step by step
Solved in 2 steps
- The following select financial statement information from Candid Photography. 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 Candid Photography if industry average for accounts receivable turnover ratio is 3 times and days sales in receivables ratio is 150 days?Consider again the example introduced in Section 4.5 of a credit card company that has a database of information provided by its customers when the customers apply for credit cards. An analyst has created a multiple regression model for which the dependent variable in the model is credit card charges accrued by a customer in the data set over the past year (y), and the independent variables are the customers annual household income (x1), number of members of the household (x2), and number of years of posthigh school education (x3). Figure 4.23 provides Excel output for a multiple regression model estimated using a data set the company created. a. Estimate the corresponding simple linear regression with the customers annual household income as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the customers annual household income and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year does this simple linear regression model explain? b. Estimate the corresponding simple linear regression with the number of members in the customers household as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the number of members in the customers household and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year does this simple linear regression model explain? c. Estimate the corresponding simple linear regression with the customers number of years of posthigh school education as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the customers number of years of posthigh school education and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year does this simple linear regression model explain? d. Recall the multiple regression in Figure 4.23 with credit card charges accrued by a customer over the past year as the dependent variable and customers annual household income (x1), number of members of the household (x2), and number of years of posthigh school education (x3) as the independent variables. Do the estimated slopes differ substantially from the corresponding slopes that were estimated using simple linear regression in parts a, b, and c? What does this tell you about multicollinearity in the multiple regression model in Figure 4.23? e. Add the coefficients of determination for the simple linear regression in parts a, b, and c, and compare the result to the coefficient of determination for the multiple regression model in Figure 4.23. What does this tell you about multicollinearity in the multiple regression model in Figure 4.23? f. Add age, a dummy variable for gender, and a dummy variable for whether a customer has exceeded his or her credit limit in the past 12 months as independent variables to the multiple regression model in Figure 4.23. Code the dummy variable for gender as 1 if the customers gender is female and 0 if male, and code the dummy variable for whether a customer has exceeded his or her credit limit in the past 12 months as 1 if the customer has exceeded his or her credit limit in the past 12 months and 0 otherwise. Do these variables substantially improve the fit of your model?Review the select information for Bean Superstore and Legumes Plus (industry competitors), and then complete the following. A. Compute the accounts receivable turnover ratios for each company for 2018 and 2019. B. Compute the number of days sales in receivables ratios for each company for 2018 and 2019. C. Determine which company is the better investment and why. Round answers to two decimal places.
- You are an investor looking to contribute financially to either company A or Company B. The following, select financial information as follows. Company A and company B, respectively: Beginning Account Receivable $ 50,000, 60,000; Ending Account Receivable $ 80,000, 90,000; Net credit sales $ 550,000, $460,000. Based on the information provided: compute the account receivable turnover ratio. Compute the number of days sales in receivables ratio for both companies A and company B ( round all answers to two decimals places) Interpret the outcomes stating which company you would invest in and why.Given the following data; TOTAL SALES OMR 250000 CASH SALES OMR 125000 SALES RETURN OMR 5000 OPENING SUNDRY DEBTORS OMR 20000 CLOSING SUNDRY DEBTORS OMR 10000What will be the Net credit sales? a.OMR 245000 b.OMR 200000 c.OMR 125000 d.OMR 120000The following are excerpts from the financial statements of 2018 and 2019 of Mandela Corporation. 2019 2018 Sales $187,600 $195,000 Accounts Receivable (net): Beginning of Year 68,100 66,500 End of Year 60,200 68,100 A newly hired manager has started implementing new credit policies. Required: a. As a consultant, you are contracted to analyze Accounts Receivable Turnover and Number of Days’ Sales in Receivable and provide opinion as to whether Mandela’s credit policy changes are working b. What conclusions does your analysis suggest. Are the new credit policies working?
- Use the information provided below to prepare the following for January and February 2023 as per guide lines on theouc4.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…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.…d. Bowers’ sales are seasonal, and her company produces on a seasonal basis, just aheadof sales. Without making any calculations, discuss how the company’s current anddebt ratios would vary during the year if all financial requirements were met withshort-term bank loans. Could changes in these ratios affect the firm’s ability to obtainbank credit? Explain.
- The Simmons Company is planning to request a line of credit from its bank. The following sales forecasts have been made for parts of 2017 and 2018:In RsMay 2017 150,000June 150,000July 300,000August 450,000September 600,000October 300,000November 300,000December 75,000January 2018 150,000Collection estimates obtained from the credit and collection department are as follows: collected within the month of sale, 5 percent; collected the month following the sale, 80 percent; collectedthe second month following the sale, 15 percent. Payments for labor and raw materials are typically made during the month following the month in which these costs are incurred. Total labor and raw materials costs are estimated for each month as follows:In RsMay 2017 75,000June 75,000July 105,000August 735,000September 255,000October 195,000November 135,000December 75,000General and administrative salaries will amount to approximately Rs 22,500 a month; lease payments under long-term lease contracts will be Rs…Assuming an economy have only two commercial banks in it banking system, Classic Bank and Prudent Bank. The following shows the balance sheet of the two banks as at 2019.Classic BankBalance sheet as at December, 2019GHSm GHSmAssets: Liabilities & Equity:Reserves 1,000 Deposits 3,000Securities 2,000 Equity 7,000Loans & Advances 1,000Property, Plant and Equipment 6,000 .10,000 10,000Prudent BankBalance sheet as at December, 2019GHSm GHSmAssets: Liabilities & Equity:Reserves 600 Deposits 2,500Securities 1,500 Equity 4,400Loans & Advances 800Property, Plant and Equipment 4,000 .6,900 6,900Assume a required reserve ratio of 10%.What is the amount of excess reserves in this commercial banking system?Assuming an economy have only two commercial banks in it banking system, Classic Bank and Prudent Bank. The following shows the balance sheet of the two banks as at 2019.Classic BankBalance sheet as at December, 2019GHSm GHSmAssets: Liabilities & Equity:Reserves 1,000 Deposits 3,000Securities 2,000 Equity 7,000Loans & Advances 1,000Property, Plant and Equipment 6,000 .10,000 10,000Prudent BankBalance sheet as at December, 2019GHSm GHSmAssets: Liabilities & Equity:Reserves 600 Deposits 2,500Securities 1,500 Equity 4,400Loans & Advances 800Property, Plant and Equipment 4,000 .6,900 6,900Assume a required reserve ratio of 10%.(a) What is the amount of excess reserves in this commercial banking system?…………………………….………………………………………………………………………………………………………………………………………………….……………………………………..……………………………………………………………………………….…………………………………………………………………………………………………………………………………………………(b)What is the maximum amount that the money supply can be expanded?What would be the effect of a fall in…