A loan processing operation that processes an average of 7 loans per day. The operation has a design capacity of 12 loans per day and an effective capacity of 9 loans per day. a. Calculate the Utilization b. Calculate the Efficiency
Q: What happens when you complete the Manage Bounced Cheque form? a. The invoice will be marked…
A: A bounced check, also known as a dishonored or returned check, occurs when a check that has been…
Q: Assuming a discount rate of 6%, what is the present value of 100,000 per year for 12 years if the…
A: The payments occur at the beginning of each period is called an annuity due. Present value of…
Q: You hope to have $35,000 in your investment account in ten years. If you invest $25,000 today, what…
A: Present value is a financial concept that represents the value of a future sum of money in terms of…
Q: A shady individual has approached you for a loan. He promises to pay you $500 at the end of five…
A: Step 1 The sum that a sequence of future payments are currently worth is known as the present value.…
Q: Which of the following statements is CORRECT? Assume that the project being considered has normal…
A: IRR stands for Internal Rate of Return, which is a financial metric used to evaluate the…
Q: 3) Angelo plans to invest an equal amount of $2,000 every six months beginning this year. The…
A: We have to calculate the future value of the annuity. There is a formula that can be used to…
Q: Calculate the Accounts Receivable Turnover and Average Collection Period using the following…
A: Accounts receivable means customer accounts to whom credit sales has been made but amount has not…
Q: A 12-year-old child received an inheritance of $9000 per year. This was to be invested and allowed…
A: Formula to calculate FV: F = P * ([1 + i]^N - 1 )/i Wherein: P = $9,000 deposited annuallyi =…
Q: BH Corp's free cash flow to equity holders is expected to be $114 million for years 1-3 and is…
A: The value of a stock today is the present value of all its future cash flows. This is the basic…
Q: A project has an initial cash outflow of $40,500 and produces cash inflows of $16,450, $17,800, and…
A: Discount rate = 11.5% Year Cash flow 0 -40500 1 16450 2 17800 3 16374
Q: The average accounting rate of return (AAR): is the primary methodology used in analyzing…
A: Step 1 Average annual profit divided by initial investment equals annual return rate (ARR). Due to…
Q: Ef 02.
A: Accounts payable means those supplier accounts from whom goods has been purchased on account and…
Q: The real risk-free rate is 2.25%. Inflation is expected to be 2.5% this year and 4.25% during the…
A: Real risk free rate=2.25%Current inflation rate=2.5%Predicted inflation rate=4.25%Maturity risk…
Q: Derive the probability distribution of the 1-year HPR on a 30-year U.S. Treasury bond with a coupon…
A: As per the given information: Par value = $100Coupon rate = 4%Coupon = $100Original maturity period…
Q: Find the monthly payment for the loan indicated. (Round your final answer to two decimal places.)…
A: Formula to calculate EMI: EMI= (P X R/12) X [(1+R/12) ^N] / [(1+R/12) ^N-1] Wherein: P = Loan…
Q: a. Compute the historical volatility in terms of annualized standard deviation on the IBM shares,…
A: Return in February (Month2)=((Price in February(Month2))/(Price in January(Month1)))-1 Return in…
Q: 13. An aircraft push truck costs $2,000,000 with an annual operating and maintenance (O&M) cost of…
A: Present worth means the sum of all the present values of cash flows from an asset. It is basically…
Q: What is the value of a call option or a put option if the stock price is zero? What if the stock…
A: The value of a call option or a put option is directly linked to the underlying asset's price, which…
Q: The compounding periods and the payment periods are the same for an annuity and for an amortization.…
A:
Q: If you deposit $1000 in one year, $2000 in two years, and $3000 in three years, how much will you…
A: Future value (FV) is the value of an investment or cash flow at a specific point in the future,…
Q: 18 00:37:07 The most recent financial statements for Alexander Company are shown here: Balance Sheet…
A: Sales: The sale represents a transaction among two or more parties wherein goods & services are…
Q: In 3 years, you will receive $4,000. One year after that, you will receive the first of 8 annual…
A: Future Value: It represents the future expected value of the current cash flow stream compounded…
Q: 3. A company functioning from a rented building, decides to buy a new building for its head office.…
A: The breakeven point is determined by dividing the set production costs by the unit price less the…
Q: The compounding periods and the payment periods are the same for an annuity and for an amortization.…
A: Present value of annuity is the current value of the future payments that are calculated using the…
Q: You will be paid 16,500 in 12 years. Assuming a discount rate of 19%, how much is this payment…
A: Present value (PV) is the current value of a future payment or a stream of future payments,…
Q: The value of a share is given by the present value of which cash flow(s): Future dividends only O b.…
A: A share's worth determined by its present value An investor must figure out the present worth of…
Q: During the year, Broozer’s increased its accounts receivable by $240, increased its inventory by…
A: increased in accounts receivable = $240 increased in inventory = $195 decreased in accounts payable…
Q: Which statement describes a technique used to address the issue of ensuring the payment of adequate…
A: Establishing an irrevocable trust can ensure that assets are set aside to pay child support,…
Q: 4. You are considering buying a new house. The house you want will cost you $150,000. You have…
A: A mortgage is a type of loan that is used to purchase a property or real estate. The borrower (also…
Q: An asset is projected to generate 17 annual cash flows of $36,000 starting 5 years from today. If…
A: Present Value: It represents the current worth of the future expected cash flows. It is computed by…
Q: 11 12 13 4 5 6 10. So you can retire early, you have decided to start saving $500 a month starting…
A: The acronym "Number of Periods" is NPER. the number of times it takes to pay off the loan amount at…
Q: Lifecycle Motorcycle Company is expected to pay a dividend in year 1 of $2, a dividend in year 2 of…
A: Dividend discount model (DDM) According to DDM, the current value or price of a stock should be the…
Q: Last year Vaughn Corp. had sales of $315,000 and a net income of $17,832, and its year-end assets…
A: The DuPont equation is a financial formula that breaks down the return on equity (ROE) into its…
Q: An engineer has received two bids for an elevator to be installed in a new building. Given a 10%…
A: Equivalent Annual Cost: It represents the annual cost of maintaining, operating, and owning the…
Q: What is the ROE for 2021? 2020 2021…
A: Return on Equity (ROE) is one of profitability ratio being used in business. This shows how much net…
Q: A bond investor is analyzing the following annual coupon bands: Issuing Company Johnson Incorporated…
A: Bonds are fixed-income assets that serve as a representation of investor loans to borrowers…
Q: Determine the amount of the ordinary annuity at the end of the given period. (Round your final…
A: To determine the future value of an ordinary annuity, we can use the formula: FV = PMT x [(1 + r)^n…
Q: O'Brien Inc. has the following data: rRF = 5.00%; RPM = 9.00%; and b = 0.65. What is the firm's cost…
A: CAPM is capital asset pricing model which is used for calculating expected returns. Under this, risk…
Q: The appropriate increment investment from one project to the other has an IRR of percent. Therefore,…
A: To determine the incremental IRR we first need to build the cash flows for each project. The formula…
Q: The three options' expected net present value (NPV) and profitability indexes (PI) has been…
A: Capital budgeting techniques are methods used by companies to evaluate potential investment projects…
Q: You plan to buy an 8% coupon 8-year maturity bond when market rate of return of similar bond is 10%.…
A: The real rate of return is the return calculated after adjusting the inflation.
Q: Anne and Jose Romero are in the 24 percent marginal federal tax bracket. Two years ago they…
A: Capital gain arises when a capital asset is sold and when there is a profit or a gain from the sale…
Q: Payout and retention ratio: Goodwin Corp. has revenues of $12,112,659, costs of $9,080,545, interest…
A: The dividend payout ratio is a financial metric that measures the proportion of earnings paid out to…
Q: Last year, Industrial Industries had current assets of $445,000 and current liabilities of $387,000.…
A: Last year current assets = $445,000 Last year current liabilities = $387,000 Current year current…
Q: an you show how to input in excel using the pmt formula thank you so much
A: In Excel, PMT is a financial function that calculates the periodic payment amount for a loan or…
Q: The following table summarizes the yields to maturity on several one-year, zero-coupon securities:…
A: Here, Yield of treasury = 3.07% Yield of AAA corporate = 3.15% Yield of BBB corporate = 4.15% Yield…
Q: NPV and IRR Benson Designs has prepared the following estimates for a long-term project it is…
A: Formula for NPV : NPV = Initial Investment + C1/(1+r) + C2/(1+r)^2 + C3/(1+r)^3 + ......... +…
Q: Describe what a cash budget entails.
A: A cash budget is a financial planning tool that helps businesses and individuals manage their cash…
Q: Squire Inc.'s 5-year bonds yield 12.50%, and 5-year T-bonds yield 4.80%. The real risk-free rate is…
A: Bond yield = 12.50% Time = t = 5 years real risk-free rate = r* = 2.75% inflation premium = IP =…
Q: Nagel Equipment has a beta of 0.68 and an expected dividend growth rate of 3.90% per year. The…
A: Security Market Line The capital asset pricing model is graphically represented by the security…
PLEASE EXPLAIN TO BETTER UNDERSTAND.
Step by step
Solved in 2 steps
- Use Goal seek on the loan amount of $825,000. You would like the monthlypayment to be $4500.00. Find a solution for new loan amount, term, and Interestrate. Do not overwrite the Existing data on D3. Hint: Use Cancel when goal seekfinds a solution. Write the solution in the space provided on a spreadsheet.Select the correct choice that completes the sentence below. The rebate amount is equal to the rebate fraction O A. multiplied by the total finance charge O B. multiplied by the number of months of a loan OC. divided by the number of weeks of the loan O D. divided by the total interestUsing the information provided please show all work and formulas in excel ! Suppose that you have two loan choices with monthly payments (a) What is the incremental borrowing cost of $30,000 for loan 1 over loan 2 if you hold the loan for the entire term and there are no origination costs for the two loans? (b) What is the incremental borrowing cost of $30,000 for loan 1 over loan 2 if you hold the loan for only 6 years (72 months) and there are no origination costs for the two loans?
- Find the interest earned on $5,750 deposited into a savings account for 3 1/2 years at an annual interest rate of 4 1/2% a. What formula should be used? b. What are you trying to find and what variable does it represent in the formula? c. Solve the problem showing all of your work (must show all steps!!) d. Interpet your answer using a complete sentence You may use the box below to upoload a picture of your written explanation or type it out in the box. Use the "mountain" button to add pictures.Find the following. (Round your answers to the nearest cent.) FinanceCharge Number ofPayments Frequency Amount Number ofPayments Left $9.10 12 Monthly $15 5 (b) the amount needed to pay off the loanConsider the following data (in millions) from Trident Financial Inc., which has two main divisions, mortgage loans and consumer loans: Mortgage Loans Consumer Loans Average total assets $ 1,200 $ 21,500 Operating income $ 255 $ 2,795 Return on investment (ROI) 21.25 % 13.00 % Required: 1. Based on ROI, which division is more successful? multiple choice Mortgage loans Consumer loans 2. Trident uses residual income (RI) as a measure of the financial performance of its divisions. What is the RI for each division if the minimum desired rate of return is (a) 10%, (b) 15%, and (c) 20%? (Leave no cells blank. Enter "0" wherever required. Negative amounts should be indicated by a minus sign. Enter your answers in millions of dollars, rounded to nearest whole number.)
- Calculate the CAT (total annual cost) for option 1 and then find which option is better to ask for a loan and explain why is it better. 1. Personal Loan MNL Bank 2.25% simple monthly interest rate 2. Savings Bank CAT= 30% 3. XYZ Bank CAT= 28.30% 4. 123 Bank CAT= 26.64%For the following economic calculations, write the factors (multipliers) that should be used,in (i) using the parameter values, and in (ii) calculate the result by showing your computations. Write the results you find in the spaces left. (Use factors for your calculations.)EXAMPLE: If you deposit $ 100 to a bank account that earns 8% annual interest, how much money will you have in this account after five years?(i)(F/P, 8%, 5) (ii)146.93100 * (F/P, 8%, 5) = 100 * 1.4693 = 146.93 TLa. You plan to take a credit with $1500 installment size per year with an annual interest rate of 8% over six years from a bank. What is the amount of your current credit?(i) (ii)b. A bank is required to deposit money for four years with an interest rate 10%. The money deposited at the end of the first year is 6000 TL and the amount of money deposited in the next three years will be reduced by 500 TL every year. How much money will be in the bank at the end of the fourth year?(i) (ii)A Input Area: Interest Income $ Amount of line of credit Term (months) Annualized interest rate on line of crdt Interest Cost Average deposit balance Annualized interest rate on deposit bal Expected Revenues Loan commitment fee (1%) Deposit management fees Wire transfer fees B Fees for agency services Expected Costs Cost of other funds raised Account activity costs Wire transfer costs Loan processing costs Recordkeeping costs Output Area: Expected Revenues Interest income from loan (4%, 9 mo,) Loan commitment fee (1%) Deposit management fees Wire transfer fees Fees for agency services Total Revenues Expected Costs Interest paid on customer deposits Cost of other funds raised Account activity costs Wire transfer costs Loan processing costs Recordkeeping costs Total Costs Total Revenues - Total Costs Before-tax rate of return over costs from the entire relationship C 10,000,000 6 4.00% 2,125,000 2.50% 100,000 4,500 3,500 4,500 180,000 5,000 1,300 12,400 4,500 D E
- Consider the following data (in millions) from Trident Financial Incorporated, which has two main divisions, mortgage loans and consumer loans: Mortgage Consumer Loans Loans Average total assets Operating income Return on investment (ROI) $ 2,500 $ 530 $ 17,750 $ 2,485 21.20% 14.00% Required: 1. Based on ROI, which division is more successful? Mortgage loans Consumer loans 2. Trident uses residual income (RI) as a measure of the financial performance of its divisions. What is the RI for each division if the minimum desired rate of return is (a) 10%, (b) 15%, and (c) 20%? (Leave no cells blank. Negative amounts should be indicated by a minus sign. Enter your answers in millions.) Residual Income (RI) Mortgage Loans Consumer Loans (а) 10% |(b) 15% (c) 20%Calculate the table factor, the finance charge, and the monthly payment (in $) for the loan by using the APR table. (Round your answers to the nearest cent.) AmountFinanced Number ofPayments APR TableFactor FinanceCharge MonthlyPayment $700 18 16% $ $ $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 $162.33 31 $ $