A mortgage service office has the following four activities involved in approving a loan application. Note that a working day is 8 hours and there are 60 minutes in one hour Activity Time (minutes) A. Property survey 23 B. Credit report 21 C. Title search 42 D. Final decision 20 Activities B and Care combined together and assigned to two emplayees, while the other two employees are responsible for activities A and D respectively. What is the mortgage office's d
Q: Stationery: During the year to 31 December 20X9 £1,300 was paid in respect of stationery. The amount…
A: The question is based on the concept of Financial Accounting.
Q: 4 Purchased office furniture on account, $4,200. The furniture should last for five years. 5…
A: Trial Balance: Trial Balance confirms that all the debit balances equal credit balances. It is a…
Q: Bev Wynn, vice president of operations for Dillon County Bank, has instructed the bank’s computer…
A: Interest on loan: Interest on loan is the amount charged on the loan principal for the privilege of…
Q: Thunder Cat Services specializes in training and veterinary services to household pets, such as…
A: Note: Since we are entitled to answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit…
Q: Chicago Consulting, an engineering consulting firm, provided $6,000 of services to a client; the…
A: Firm has provided service to the client of $6,000 but client had paid only $2,000 right now and will…
Q: Required information [The following information applies to the questions displayed below.] National…
A: Allocation of cost :— It means distribution of cost to their cost object on the basis of allocation…
Q: The following T accounts show transactions that were recorded by Residential Relocators, a firm that…
A: In accountancy, company provide business related information to its stakeholders by using financial…
Q: When would Runway record the $25 Referral Credit? What are the entries Runway would record when the…
A: Journal: Recording of a business transactions in a chronological order.
Q: Selected transactions for Concord’s Dog Care are as follows during the month of March. March 1…
A: Record journal entries for transactions occurred in the month of March as shown below:
Q: . Agnes Abanilla was granted a loan of $20,000 by her employer CPM Industrial Fabricator and…
A: Disclaimer: “Since you have asked multiple question, we will solve the first question for you. If…
Q: Precilla, vice-president of operations for Sturgis National Bank, has instructed the bank's computer…
A: No ,Precilla is not behaving in professional manner. It has an impact on stakeholder interests.…
Q: Ultra Day Spa provided $93,650 of services during Year 1. All customers paid for the services with…
A: The balance sheet includes the assets, liabilities, and stockholders' equity of the company.…
Q: Consider the following situations and determine (1) which type of liability should be recognized…
A:
Q: The activity on Marny Zell's MasterCard account for one billing period is shown below. Find the…
A: Average daily balance Average daily balance is a useful accounting method utilized by the credit…
Q: A contractor established a $150,000 line of credit with a bank. When it was established, 2 points…
A: The 2 points means 2%. Each point equals one percent of the loan amount.
Q: Glen received $2,250 loan from bank. After six months, he paid back $2,295 and closed the loan.…
A: Borrowings are the liability that is used to finance the requirement of the funds. The borrower…
Q: The buyer was given a loan estimate at the time of the application for the mortgage and it is now…
A: The Closing Disclosure is a five-page document that details the important features of a mortgage…
Q: any el Ahuehuete, S.A., shows you the data of the credit applicants. Without knowing the rules and…
A: Giving credits to clients require analysis of income and expenses and depending on that credit may…
Q: When opening a new business account on QuickBooks in July, but the business actually opened in…
A: Property purchased on mortgage means that the lender of money has provided the loan secured against…
Q: An attorney performs services of $1,100 for a client and receives $400 cash, with the remainder on…
A: Journal entries are the primary reporting in the books. These are recorded in the books to maintain…
Q: An attorney performs services of $1,100 for a client and receives $400 cash, with theremainder on…
A: Journal: Recording of a business transactions in a chronological order.
Q: Please provide journal entries for the following: 1. Deposited P900,000 in the bank and contributed…
A: Journal Entry: Journal entry is the act of keeping records of transactions in an accounting journal.…
Q: When preparing a report form of a Balance Sheet for a merchandising business, assume that the…
A: The correct answer is $30,000.
Q: Berger Mortgage Co. provides the following data on its loan application processing activities for…
A: The cycle efficiency is calculated as process time divided by manufacturing cycle time.
Q: nstructions: Prepare a Statement of Financial Position of Happy Selling Co. using the following…
A: Balance sheet or statement of financial position is that statement which helps stakeholders to…
Q: In a loan database, there are 81 loans to clients with 19 years of business experience. Also, there…
A: Given: n(19 years experience) = 81 n( College graduation ) = 73 n( 19 years experience or College…
Q: I need to know how to recoed this transaction in a general journal. Completed consulting job for…
A: Journal entries is recording the of the transaction in the accounting journal in a chronological…
Q: How would I solve this?
A: Record journal entries for Pet sitter\'s Inc as shown below:
Q: The activity on Marny Zell's MasterCard account for one billing period is shown below. Find the…
A: Finance charge is a fee for cost of credit.
Q: Suppose the charge account of Strong's Mailing Service at the local supply store had a 1.8% interest…
A: The billing cycle is the time gap between two closing dates of the company. The ending balance is…
Q: This is a sample application form for business loan in a bank. Directions: Fill out the form with…
A: In the context of the given question, we will try to cover filling out all sections of the bank loan…
Q: The following T accounts show transactions that were recorded by Residential Relocators, a firm that…
A: T-Accounts with closing balances
Q: Use the following information to complete the general journal below. (17-26) Be careful to notice if…
A: Journal Entry The purpose of preparing the journal entries to enter the required transaction into…
Q: The activity on Charlie Wilson's Visa account for one billing period is shown below. Find the…
A: Given information: Previous balance amounted to $645.33 Annual interest rate is 20%
Q: The following T accounts show transactions that were recorded by Residential Relocators, a firm that…
A: Net income for year = fees earned - salary -telephone expense = 19000+10200-9900-590 = 18710
Q: Bob Sample opened the campus Laundromat on Sep.1. During the first month of operation the following…
A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: When preparing a report form of a Balance Sheet for a merchandising business, assume that the…
A: The correct answer is $150,000.
Q: When Margie's Convenience Store buys building supplies from Kent and is granted 30 days to pay the…
A: The liabilities are classified as current liabilities and non current liabilities.
Q: Shafinaz running a medium-sized 24 hours petrol station kiosk at Johor Bahru, Johor. The petrol…
A: Internal control system is the system which is put in place by the company in order to detect and…
Q: For each of the following independent items, indicate when revenue should be recognized. a. Interest…
A:
Q: Joan Jenkins had a beginning balance of $1000 on her credit card as of October 1 last month. On…
A: Computation of average daily balance:Hence, the average daily balance is $991.Answer: Option C
Q: Bob Sample opened the campus Laundromat on Sep.1. During the first month of operation the following…
A: Introduction : Journals: Recording of a business transactions in a chronological order. First step…
Q: A dentist opens a dental practice by depositing $10,000 into a bank account in the business name The…
A:
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- 1) Use the Loan worksheet to complete the loan amortization table. In cell F2, insert the IPMT function to calculate the interest for the first payment. Copy the function to the range F3:F25. (The results will update after you complete the other functions and formulas.) 2) In cell G2, insert the PPMT function to calculate the principal paid for the first payment. Copy the function to the range G3:G25. 3) In cell H2, insert a formula to calculate the ending principal balance. Copy the formula to the range H3:H25. 4) Now you want to determine how much interest was paid during the first two years. In cell B10, insert the CUMIPMT function to calculate the cumulative interest after the first two years. Make sure the result is positive. 5) In cell B11, insert the CUMPRINC function to calculate the cumulative principal paid at the end of the first two years. Make sure the result is positive. 6) You want to perform a what-if analysis to determine the rate if the monthly payment is…The following partially completed table shows information for four different payday loans. Fill in themissing information in the table. Use the example as a guide.The following partially completed table shows information for four different payday loans. Fill in the missing information in the table. Use the example as a guide. Help please?
- Loan Servicing Companies.. O Collects monthly payments, remits to investor O Purchase loans on the secondary market O Decide on credit criteria for new loans O Underwrite home loansA 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 borrowerA borrower has two alternatives for a loan: (1) issue a $360,000, 75-day, 6% note or (2) issue a $360,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. Calculate the amount of the interest expense for each option. Round your answer to the nearest dollar. $ ________________________ Determine the proceeds received by the borrower in each alternative. Round your answers to the nearest dollar. (1) $360,000, 75-day, 6% interest-bearing note: $___________________________ (2) $360,000, 75-day note discounted at 6%: $ _________________________
- 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 interestYou have just been hired as a loan officer at a national bank. Your first assignment is to calculate the amount of the periodic payment (in $) required to amortize (pay off) the following loan being considered by the bank (use Table 12-2). (Round your answer to the nearest cent.) LoanPayment PaymentPeriod Term ofLoan (years) NominalRate (%) Present Value(Amount of Loan) $ every month 1 1 4 6 $30,000A borrower has two alternatives for a loan: (1) issue a $420,000, 30-day, 6% note or (2) issue a $420,000, 30-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. Calculate the amount of the interest expense for each option. Round your answer to the nearest dollar. $ fill in the blank 2 for each alternative. Determine the proceeds received by the borrower in each alternative. Round your answers to the nearest dollar. (1) $420,000, 30-day, 6% interest-bearing note: $ fill in the blank 3 (2) $420,000, 30-day note discounted at 6%: $ fill in the blank 4 Alternative 1 is more favorable to the borrower because the borrower receives more cash .
- 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.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 $1,700 18 $123.89 12You have just been hired as a loan officer at a national bank. Your first assignment is to calculate the amount of the periodic payment (in $) required to amortize (pay off) the following loan being considered by the bank (use Table 12-2). (Round your answer to the nearest cent.) LoanPayment PaymentPeriod Term ofLoan (years) NominalRate (%) Present Value(Amount of Loan) $ 2,582 every month 1 1 4 6 $30,000 loan payment wrong needs correction