Evaluating alternative notesA borrower has two alternatives for a loan: (1) issue a $510,000, 45-day, 8% note or (2) issue a $510,000, 45-day note that the creditor discounts at 8%. 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.Open spreadsheeta. Calculate 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 alternative. Round your answers to the nearest dollar.(1) $510,000, 45-day, 8% interest-bearing note: $(2) $510,000, 45-day note discounted at 8% : $$c. Alternativeis more favorable to the borrower because the borrower

A note is a piece of paper that acts as a legal representation of a loan that has been given by an…

Answered: A borrower has two alternatives for a…

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter6: Using Credit

Section: Chapter Questions

Problem 9FPE

See similar textbooks

Similar questions

A 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%: $ _________________________
A 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 .
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.
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 $7,900 36 10% $ $ $ https://www.webassign.net/brecmbc9/13-table-1.pdf
Carl Sonntag wanted to compare what proceeds he would receive with a simple interest note versus a simple discount note. Both had the same terms: $19,500 at 8.00% for 2 years. Compare the proceeds. Face value Interest Rate: Term: 19,500 Required: Using the information above please answer the following: 1. What is the simple interest note? 2. Proceed amount 3. Simple discount note proceeds: Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. Open Excel in new tab
With loans, spreadsheets make it easy to _____. (can be more than 1 of the options listed below) a. Calculate the amortization schedule b. Determine the number of remaining loan payments c. Find the loan balance due at any time d. Demonstrate the split between the principal and interest amounts.
LATION Saved V Mailings Review View Help Grammarly lity: Investigate O Search (Alt+Q) The balance on a credit card, that charges a 10.5% APR interest rate, over a 1 month period is given in the following table: I Days 1-5: $200 (initial balance) Days 6-20: $350 ($150 purchase) Days 21-30: $150 ($200 payment) What is the finance charge, on the average daily balance, for this card over this 1 month period? finance charge = $ [?] Round to the nearest hundredth. DELL Enter
Match the following credit terms with the correct description. APR [Choose ] [Choose ] Known as the Annual Percentage Rate. Some credit cards charge these. They can be charged for membership and you may be required to pay them once a year. Credit cards that offer these give you cash or points for purchases you make. Occurs when you don't pay your monthly payment on time. These occur when you transfer your balance to a different card. When you move an existing balance to another credit card or account. The least amount of money you are obligated to pay back on a monthly basis to avoid fees and penalties. [Choose ] [Choose ] [Choose ] [Choose ] Fees Rewards Finance Charges Late fees Balance Transfer Minimum payment
Alexa takes out a loan of 94,000 at an annual effective discount rate of 6%. The loan is to be repaid with annual payments of 10,000. The first payment is due 4 years after the loan is taken out. Calculate the amount of the drop payment. Select an answer and submit. For keyboard navigation, use the up/down arrow keys to select an answwer.
Cy loans Mookie The Beagle™ Concierge $2,000 at 6% annual interest. Record the transaction as a loan payable as follows. Complete a Deposit. Select Create (+) icon > Bank Deposit Select Account: Checking Select Date: 01/12/2022 In Add Funds to This Deposit section, select Account: + Add New > Loan Payable > Account Type: Other Current Liabilities > Detail Type: Loan Payable > Name: Loan Payable, then select Save and close Select Payment Method: Check Enter Ref No.: 5002 Enter Amount: 2000.00 Select Save and close What is the Amount of the Loan Payable? (Answer this question in the table shown below. Round your answer 2 decimal places.) View the Transaction Journal for the Deposit. From the Navigation Bar, select Accounting From the Chart of Accounts, select Loan Payable > View Register From the Register, select the transaction just recorded > Edit From the bottom of the Loan Payable transaction, select More > Transaction Journal What are the…
Evaluating alternative notesA borrower has two alternatives for a loan: (1) issue a $360,000, 60-day,5% note or (2) issue a $360,000, 60-day note that the creditor discounts at5%.a. Calculate the amount of the interest expense for each situation.b. Determine the proceeds received by the borrower in eachsituation.c. Which alternative is more favorable to the borrower? Explain.
Assume that your team is in business and you must borrow $6,000 cash for short-term needs. You have been shopping banks for a loan, and you have the following two options. A. Sign a $6,000, 90-day, 10% interest-bearing note dated June 1. B. Sign a $6,000, 120-day, 8% interest-bearing note dated June 1. Required 1. Discuss these two options and determine the better choice. Ensure that all teammates concur with the decision and understand the rationale. 2. Each member of the team is to prepare one of the following journal entries. a. Option A—at date of issuance. b. Option B—at date of issuance. c. Option A—at maturity date. d. Option B—at maturity date. 3. In rotation, each member is to explain to the team the entry he or she prepared in part 2. Ensure that all team members concur with and understand the entries. 4. Assume that the funds are borrowed on December 1 (instead of June 1) and your business operates on a calendar-year reporting period. Each member of the team is to prepare…

SEE MORE QUESTIONS

Recommended textbooks for you

Pfin (with Mindtap, 1 Term Printed Access Card) (…

Finance

ISBN:

9780357033609

Author:

Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Pfin (with Mindtap, 1 Term Printed Access Card) (…

Finance

ISBN:

9780357033609

Author:

Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS