Question: can anyone explain the excel method for this question please? A design studio received a loan of $9,600 at 3.70% compounded semi-annually to purchase a

can anyone explain the excel method for this question please?

A design studio received a loan of $9,600 at 3.70% compounded semi-annually to purchase a camera. If they settled the loan in 3 years by making quarterly payments, construct the amortization schedule for the loan and answer the following questions: a. What was the payment size? Round to the nearest cent b. What was the size of the interest portion on the first payment? b. What was the size of the interest portion on the first payment? Round to the nearest cent c. What was the balance of the loan at end of the first year? Round to the nearest cent d. What was the size of the interest portion on the last payment

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Compute the reactions for the beam in Figure 3.22a. A load of 12 kips is applied directly to the hinge at C. Figure 3.22a A 10. B By hinge 24 kips D 12 kips 55: in E E Ex

IMPORTANT: This question was answered incorrectly last time, please make sure the answer is correct! Thanks An example of how to solve a similar problem is provided below for your referance: A design...

hello i need help with these math questions please and thank you Question 5 of 11 Dustin had a loan of $221,000 and made payments of $3,750 at the end of every month to settle it. If he received the...

Question 1 of 6 Jacqueline's student loan of $28,000 at 4.82% compounded quarterly was amortized over 4 years with payments made at the end of every month. What was the principal balance on the loan...

Question 3 of 8 A design studio received a loan of $5,850 at 6.50% compounded semi-annually to purchase a camera and settled the loan in 2 years by making quarterly payments. a. What was the size of...

I need help with these questions. Please indicate your full solution via by hand or Excel. Thank you. A design studio received a loan of $7,600 at 5.10% compounded semi-annually to purchase a camera....

Dear Friends, I need the solution by today 11.00 PM. Its really important. I dont have lot of funds. I can only pay $10. Max Harvard Business School 9-292-140 June 12, 1992 Arundel Partners: The...

Can anyone solve the answers from the given document givenbelow? I really need help. MY FINAL LITERALLY IS KNOCKING AT THE DOOR. Name_________________________________ Student...

Hoyt, Inc. has estimated current year sales (in millions) for the next four quarters. Q1 $240Q2 $250 Q3 $205 Q4 $350 ? Sales for the 1st quarter next year are projected to be $230.? Accounts...

1. A bank is paying interest at a 5% annual rate on deposits. If you invest 10,000 and the bank compounds interest daily (i.e., 365 times per year), which of the following shows how much you will...

SOMEONE PLEASE HELP ME GIVE ALL THE ANSWERS!!!!! MY EXAM IS ON 13th MORNING! SO PLEASEEEEE!!!!! 2. An investment is expected to pay the following: C 1 = $2,300, C 2 = $2,600, C 3 = $2,900, and then...

Discuss the following in relation to Indexing files: (a) how do they work and what are they useful for. Refer to at least 2 types of indexing files. (b) List their strengths and weaknesses. (c)...

Identify several types of printers. What are the advantages and disadvantages of each type?

which of the following is true regarding options? A . Speculator sell at the money put options when they expect that the currencies value will rise

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...