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: Blue Red Company Company Net credit sales P675,000 P560,000
Q: 2. [Cross Rate] When 1EUR = 1.05USD and 1USD = 130JPY, calculate: 1EUR = JPY
A: 1EUR = 1.5USD 1USD = 130JPY
Q: III. Find the Net Price rate (or complement of discounts), Net Price, and Total discount. Round to…
A: Trade dscount is the discount which the purchaser gets on any product. One method of calculating the…
Q: You are going to invest P20,000 in a portfolio consistin g of assets X, Y, and Z, as follows:…
A: The beta of the portfolio is calculated as sum of weight of each stock and the respective betas
Q: Calculate the company's WACC.
A: WACC or the weighted average cost of capital = ((Weight of debt*After tax cost of debt)+(Weight of…
Q: Which of the following bonds is trading at a premium? O A. a ten – year bond with a $4,000 face…
A: A bond will trade at Premium, when Coupon rate is greater than YTM A bond will trade at discount ,…
Q: Ava Co. sells custom jewelry for $200. The variable cost per jewel is $160. Ava has fixed operating…
A: Solution: Breakeven quantity of sales is that level of sales at where the firm is in situation of no…
Q: The Sebastinian Arts Guild wants P5,000 at the end of each 2-months theater season for renovations.…
A: Given, The payments required is P5000 Rate is 9% compounded annually
Q: What are the most important developments in the financial markets over the past 40 years?
A: Any market in which securities are traded is referred to as a financial market, which includes stock…
Q: Western Electric has 21,000 shares of common stock outstanding at a price per share of $61 and a…
A: The question is related Weighted Average Cost of Capital.The term cost of capital refers to the…
Q: Cameron Industries is purchasing a new chemical vapor depositor in order to make silicon chips. It…
A: Given, The cost of machine is $6,000,000 Installation charges $10,000
Q: 3b. Inflation is expected to average 2.4% per year for the next 44 years. What percentage of the…
A: We have to find the % loss in the purchasing power of the dollar under the given inflation scenario.
Q: Present Value versus Future Value
A: Present value is the amount at time "t=0". This is the value of an investment today or in present…
Q: As connoisseurs of elegant fast food cuisine, we are interested in making a bid for the Greens-to-Go…
A: Given, 3 firms With levered beta, tax rate, and debt ratio.
Q: A callable bond with £100 face value and 15 years maturity, has been issued at par with a coupon…
A: Face Value £ 100.00 Time Period 15 Coupon Rate 10%…
Q: Compute the price of a share of stock that pays a 2 per year dividend and that you expect to be able…
A: Shares, often known as stocks or stock shares, indicate a corporation's equity ownership divided…
Q: Capital Asset Pricing Model a) describe the model b) what are the assumptions in the model c)…
A: a) CAPM Model CAPM model ideally portrays the relationship between systematic risk and the expected…
Q: Malenia is looking to purchase a 10-year, $10,000 face value zero coupon bond. Assuming the current…
A: Price of zero-coupon bond = Face value / (1 + r) n Wherre, r = interest rate N = Time period a)…
Q: If Magui will invest her money today worth 500,000 in JMC Mining company, how much is the expected…
A: Given, Working, For the Calculation of the the investment after 10 years, We have to calculate the…
Q: The asset's market risk premium is
A: Market risk premium = Return on market portfolio - Risk free rate of return
Q: Harper Corporation has the following information about the purchase of a new piece of equipment:…
A: Given Cash revenues less cash expenses $50,000 per year Cost of equipment $130,000 Salvage value at…
Q: The article emphasises that information technology is any technology that enables humans to create,…
A: Its use of computers, memory, networking, and other physical devices, infrastructures, and processes…
Q: Mergers often are classified according to the merger's participants and their lines of business.…
A: Mergers are a type of agreement where two or more companies decide to form a single entity.
Q: ERGPeise 18-2 (Aigo) Financial Ratios for Assessing Liquidity (LO16-2] Comparative financial…
A: a) Working Capital = Current Assets- Current Liabilities = 25,460 - 20,440 = 5,020 b) Current…
Q: A firm's overall cost of capital that is a blend of the costs of the different sources of capital is…
A: A company can raise funds through 1. Equity and 2. Debt issue
Q: Suppose that the general inflation rate is 5% and the real interest rate is 3%. Find the market…
A: Inflation can be defined as the increase in general price levels in the market. Inflation reduces…
Q: An investor buys a land for PhP 1M and constructs a three-door apartment for students worth PhP 5M.…
A: Here, Cost of Land is Php 1 million Cost of Apartment is Php 5 million Annual Revenue is Php 1.2…
Q: Okay credit is between
A: A credit score is a three-digit figure that varies between 300 and 900. The credit reporting…
Q: 6b. An initial $2000 investment is made that returns profits of $1000 and 1500 in the first and…
A: Here, Initial Investment is $2,000 Profit in Year 1 is $1,000 Profit in Year 2 is $1,500 Inflation…
Q: Practice 1 In-place overhead crane that cost $350,000 three years ago can be purchased used on…
A: Given, Cost of crane =$350,000 (3 years ago)Purchase price=$200,000 (present)Crane's Book value=…
Q: O. /4
A: Method 1: 3/6..dividing numerator and denominator by 3 Then It is equal to 1/2 1/2 > 1/4…
Q: A) The rate of return on a bond is expected but the interest rate is unexpected.
A: Interest rates refer to the proportion of the loan which is to be paid by the borrower to the lender…
Q: Q. Jayden borrows $10500 from his grandmother for 4 years. Jayden’s grandmother gives Jayden a…
A: While calculating future value using simple interest, the amount of simple interest is only based on…
Q: The following information is available on two mutually exclusive projects. Project…
A: Project A; Cash flow; Year 0 = - $700 Year 1 = $200 Year 2 = $300 Year 3 = $400 Year 4 = $500…
Q: The following information is available on two mutually exclusive projects. Project…
A: Crossover rate is the rate at which the NPV of the two projects are equal. NPV is the sum of present…
Q: All of the following statements regarding common stock valuation are correct EXCEPT I. fundamental…
A: Fundamental analysis seeks to estimate the intrinsic value of the stock through valuation models…
Q: You are planning on investing to save for retirement.You will invest $25,000 each year for 20…
A:
Q: Current Liabilibes Cash 61.2 58.5 Accounts payable Notes payable / 396 short-term debt Current…
A: Solution: We know, Net working capital means the net current assets over the current liabilities of…
Q: Consider the following cash flows. The interest rate is 10%. What is the duration (hint: you need…
A: Duration measures the sensitivity of an asset's price to changes in interest rates. Duration can be…
Q: A project requires a current expenditure of $350 and expects to generate $100 cash inflows at the…
A: We need to examine the NPV profile and decide whether to accept the project and under what…
Q: Explain what a callable bond is and under what conditions and expectations a company might wish to…
A: A callable bond can be defined as the type of bond which can be redeemed by the bondholders before…
Q: Asset P has a beta of 0.9. The risk-free rate of return is 8 percent, while the return on the market…
A: The asset required rate of return can be calculated with the help of CAPM equation
Q: 1. Determine the amount of money invested today at 12% interest can provide the following…
A: Interest rate = 12% Cash flows at end of each year for first 6 years = 312,000 Cash flows at end of…
Q: mean by payback . period? What are their significanc:s and drawbacks? Find the payback periods of…
A: 1. The payback period is the period within which the initial investment is recovered. Payback period…
Q: 5.1 Frasier needs £250,000 to set up his business. Bank A is willing to lend him the money under the…
A: Hi There, Thanks for posting the questions. As per our Q&A guidelines, must be answered only one…
Q: 1. Calculating Cost of Equity The Pierce Co, just issued a dividend of $2.35 per share on its common…
A: Cost of equity is referred as the return, where the corporation that requires regarding the project…
Q: LotsaDough's common stock is expected to pay a dividend of $1.20 next year, with a forecasted…
A: Next year dividend (D1) = $1.20 Growth rate (g) = 0.07 Stock price (P0) = $12.50 Cost of common…
Q: 12.1 Calculating the Cost of Equity Suppose stock in Boone Corporation has a beta of .90. The market…
A: Cost of equity is defined as the return, where the corporation used to need for the project or…
Q: How much will the company pay in total if they are going to pay all these costs today? Interest for…
A: The amount the company will pay today can be found using the present value concept. By discounting…
Q: Could I Industries just paid a dividend of $1.25 per share. The dividends are expected to grow at a…
A: Dividend discount model refers to a stock valuation model which is used by the company for…
Q: The financial breakeven point of Soillnc. is P90,000,while the tax rate applicable to the company is…
A: The financial breakeven can be calculated by using this equation EBITFinBE =Interest cost +Preffered…
Step by step
Solved in 2 steps with 2 images
- 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 P11000.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 1. Working capital 2. Current ratio 3. Acid test ratioYou 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. P700,000.00 P650,000.00 Net credit sales 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 P94,000.00 P180,000.00 Inventory Current liabilities P110,D00.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 RED 1. Working capital 2. Current ratio 3. Acid test ratio 4. Accounts receivable turnoverConsider 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?
- Consider again the example introduced in Section 7.5 of a credit card company that has a database of information provided by its customers when they 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 post-high school education (x3). Figure 7.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 is explained by this simple linear regression model? 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 is explained by this simple linear regression model? 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 is explained by this simple linear regression model? d. Recall the multiple regression in Figure 7.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 post-high 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 7.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 7.23. What does this tell you about multicollinearity in the multiple regression model in Figure 7.23? f. Add age, a dummy variable for sex, 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 7.23. Code the dummy variable for sex as 1 if the customer 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?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 120000Study this case and answer question asked below: You have the following quotes from Bank A & Bank B Bank A: Bank B SPOT USD/CHF 1.4650/55 USD/CHF 1.4653/60 3-months 5/10 6-months 10/15 Cash/Spot 1/2 SPOT GBP/USD 1.7645/60 GBD/USD 1.7640/50 3-months 25/20 6-months 35/25 If you want to buy 1 million GBP Spot against CHF you have to pay Minimum Amount you have to pay is a. CHF 2.5866 Million b. CHF 2.5881 Million c. CHF 2.5875 Million d. CHF 2.5863 Million
- A bank’s customer wants to exercise a $6,750,000 loan commitment. Show the balance sheet after the loan is established using purchased liquidity to fund the loan. Assets Liabilities and Equity Cash $1,550,000 Deposits $7,960,000 Loans 3,470,000 Equity 1,440,000 Securities 4,380,000 Total Assets $9,400,000 Total Liabilities and Equity $9,400,000 Please answer with excel explaination. Don't upload image.Hi,how to use the excel function (IRR and Effect) to determine which money lender offers a better rate: 1. Ah Long Finance: Loan amount: $20,000; instalment $600 per month x 36 months 2. Sharky Finance: Loan amount: $30,000; instalment $555 per month x 60 months 3. Ah Beng Finance: Loan amount: 40,000; instalment $ 760 per month x 59 months 4. Barracuda Finance: Loan amount: $50,000; instalment $925 per month x 60 monthsThanks.1.You are the loan department supervisor for a bank. This installment loan is being paid off early, and it is your task to calculate the rebate fraction, the finance charge rebate (in $), and the payoff for the loan (in $). (Round dollars to the nearest cent.) AmountFinanced Number ofPayments MonthlyPayment PaymentsMade RebateFraction FinanceChargeRebate LoanPayoff $4,700 36 $168.33 31 ____ $ ____ $ ___ 2.Calculate the table factor, the finance charge, and the monthly payment (in $) for the loan by using the APR table, Table 13-1. (Round your answers to the nearest cent.) AmountFinanced Number ofPayments APR TableFactor FinanceCharge MonthlyPayment $9,400 36 13% $ ___ $ ___ $ ___
- 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…Snowflake Manufacturing [SM] has recently come to the bank you work for looking for a $280,000 long-term loan. The following data was submitted with SM's loan application: 2020 $475,200 155,400 175,200 408,600 103,500 13,200 34,200 56,100 64,200 2019 $316,500 120,000 2021 $820,800 Current assets.. Current liabilities. Non-current liabilities. Shareholders' equity.. Operating income... Interest expense... Income tax expense.. Net income... 414,600 60,800 303,700 168,900 7,200 65,400 96,300 106,300 300,000 490,200 208,500 28,500 72,000 108,000 115,000 Operating cash flow... The loan committee has asked you to analyze the data using at least three relevant financial ratios and complete a brief trend analysis. They would also like you to briefly discuss any limitations that might exist when completing this type of analysis and what data dashboards can do to help this. Finally, they have asked that your report also contain a recommendation about whether SM's loan request should be approved.…A borrower has two alternatives for a loan: (1) issue a $630,000, 75-day, 6% note or (2) issue a $630,000, 75-day note that the creditor discounts at 6%. Assume a 360-day year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet a. Compute the amount of the interest expense for each option. Round your answer to the nearest dollar. for each alternative. b. Determine the proceeds received by the borrower in each situation. Round your answers to the nearest dollar. < (1) $630,000, 75-day, 6% interest-bearing note: $ (2) $630,000, 75-day note discounted at 6%: $ c. Alternative is more favorable to the borrower because the borrower