First National Bank charges 13.7 percent compounded monthly on its business loans. First United Bank charges 14 percent compounded semiannually. Calculate the EAR for First National Bank and First United Bank. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.

PLEASE MAKE IT IN EXCEL AND SHOW THE FORMULAS (Take screenshots) La Resolana, S.A., has credit sales of $180,000 per year, with net payment terms of 30 days, which is also the average collection period. La Resolana does not currently offer any cash discounts, so customers take the 30 days to pay. What is the average accounts receivable balance? What is the accounts receivable turnover?

Master Card and other credit card issuers must by law print the Annual Percentage Rate (APR) on their monthly statements. If the APR is stated to be 19.00%, with interest paid monthly, what is the card's EFF%? a.18.58% b. 19.52% с. 20.75% d. 21.94% e. 22.65%

A loan of 15700 was charged a simple discount rate of 4.2%. If the proceeds received were 15463.72, find the amount of bank discount. Hence, find the discount period in days.

Calculate the missing information on the revolving credit account. Interest is calculated on the unpaid or previous mo th's balance. (Round dollars to the nearest cent.) Annual Monthly Finance Purchases Payments New Previous Percentage Rate (APR) (as a %) Periodic Charge and Cash and Balance Balance Rate (in $) Advances Credits (in $) 1-% $ 31.12 $2,490.00 15 % $1,354.98 $300.00 3576.1 4

Please answers parts 4,5, and 6. I have the first three already

Dave borrowed $550 on January 1, 2022, and paid it all back at once on December 31, 2022. The bank charged him a $3.50 service charge, and interest was $40.70. What was the APR? Note: Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. Annual percentage rate %

Paul and Sandy Moede signed an $7,500 note at Citizen’s Bank. Citizen’s charges a 5.4% discount rate. Assume the loan is for 270 days.a. Find the proceeds. (Use 360 days a year. Round your intermediate calculations and final answer to the nearest cent.) Proceeds     b. Find the effective rate charged by the bank. (Use 360 days a year. Do not round intermediate calculations. Round your answer to the nearest tenth percent.) Effective Rate

Concord Inc. received a five-year bank loan bearing interest at 7% with principal and interest instalment payments due annually. The following instalment payment schedule is partially completed: Fill in the missing amounts. (Round answers to O decimal places, e.g 2,345.) st 1 ite Your answer is correct. (b) Cash Payment $17,171 Current portion 17171 Non-current portion 17171 *Adjusted for rounding differences. eTextbook and Media 17171 17171 19 $ $ $ Interest Expense 4928 4,071 3154 2,173 1,129 Reduction of Principal $12,243 What are the current and non-current portions of the loan at the end of the third annual period? 13100 14,017 14998 16,042 Principal Balance $70,400 58,157 45,057 " 31040 16,042 0 Attempts: 1 of 15 used

Looking for answers. Please include all the calculations for my reference. Thanks in advance.