A business loan is amortized constantly through 35 monthly rents, if the first rent is L 8,850 and the rate is 18% compounded by months. What is the value of the credit if before starting the 35 constant amortization rents you make 10 payments of L 5,000.00. Make the amortization table in its first 10 lines and the last 5. How much is the total interest generated?. do the exercise in excel

A business loan is amortized constantly through 35 monthly rents, if the first rent is L 8,850 and the rate is 18% compounded by months. What is the value of the credit if before starting the 35 constant amortization rents you make 10 payments of L 5,000.00. Make the amortization table in its first 10 lines and the last 5. How much is the total interest generated?. do the exercise in excel

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Use the following information to answer the next 3 questions. $280,000 Loan Amount 30 year loan with monthly payments 4% quoted rate on the loan (annual rate) 2 points in costs to the lender $3,000 in other closing costs Loan is to be paid off at the end of the 4th year. What is the balance remaining on the loan after 4 years? What is the Lender's Yield? What is the Borrower's Cost? Fill this out: Loan Amount: Loan Term: Interest Rate: Lender's Points: Additional Closing Costs: Paid off in: NI/Y Loan Pay Off: Lender's Yield: Borrower's Cost:
Find the monthly payment and estimate the remaining balance. Assume interest is on the unpaid balance. 5-year computer loan for $3380 at 6.4%; remaining balance after 2 years. The monthly payment is $ (Round to the nearest cent as needed.)
You are looking at a one-year loan of $10,000. The interest rate on a one-year loan is quoted as 13 percent plus 3 points. What is the EAR? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Effective annual rate Is your answer affected by the loan amount? O Affected 16.79 % Not affected
What was the term of a $4850 loan at 4.5% if the interest due at the end was $145.50? Answer (need work shown): 8 months What annual rate of interest was earned if a $15,000 investment for 5 months earned $546.88 in interest? Answer (need work shown): 8.75%
using excel do the following Create an amoritization schedule for a $1,000,000 loan that requires equal annual payments in each of the next 10 years. The annual rate is 6%. How much is the remaining loan balance after 5 years? Analyze the amount of each equal payment that goes towards interest and principal in each year. What do you notice?
How much is your loan payment based on the following: Time - 5 years Interest Rate - 5.8% Principle Balance - $28,000 Assume the interest rate is an APR. If needed, the discount rate is 4.2%.
Suppose you take out a loan for $7,000, at 12% ordinary interest. If the amount of interest is $672, what is the time period? (Round any fraction to the next higher day.) O280 days O 284 days 288 days O 292 days
Suppose you borrow $14,000. The interest rate is 11%, and it requires 4 equal end-of-year payments. Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances. Round your answers to the nearest cent. If your answer is zero, enter "0". Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $ fill in the blank 60 $ fill in the blank 61 $ fill in the blank 62 $ fill in the blank 63 $ fill in the blank 64 2 $ fill in the blank 65 $ fill in the blank 66 $ fill in the blank 67 $ fill in the blank 68 $ fill in the blank 69 3 $ fill in the blank 70 $ fill in the blank 71 $ fill in the blank 72 $ fill in the blank 73 $ fill in the blank 74 4 $ fill in the blank 75 $ fill in the blank 76 $ fill in the blank 77 $ fill in the blank 78 $ fill in the blank 79
3. A loan of $6000 was repaid by quarterly payments of $450. If interest was 12% compounded monthly, how long did it take to pay back the loan?
Suppose you take a 3/1 interest-only ARM for $100,000, monthly payments, 30-year term. The initial contract rate is 4.00% and the contract rate for year 4 is 6.50%. What is the balance of the loan at the end of year 4? 94,892.15 98,591.88 96,483.13 95,347.22
4. You borrow $720,000 at 4.00% per year compounded monthly and you plan to pay off this loan in equal annual payments starting one year after the loan is made over a period of fifteen (15) years. What are the annual end-of-year payments? Determine the amount of interest and principal that are paid each year. What is the total interest paid for the loan? a. b. Restructure the loan in the previous question to make payments monthly. Determine the savings in interest overall. C. Restructure your payment schedule once more to make payment every two weeks. Determine the savings in interest (if any) in this case (compare to both previous repayment options). 1 OF 1
3. A loan of $50,000 due in one year is to be repaid by three equal payments due today, six months from now, and one year from now. What is the amount of the equal payments if interest is 6.5% (simple interest) and the focal date is today?