Question: Please provide your complete solutions to the given problems. You may use MS Excel for your solutions. 1. A loan is to be amortized for

Please provide your complete solutions to the given problems. You may use MS Excel for your solutions. 1. A loan is to be amortized for 4 years through equal payments of PhP48,532.49 at the end of every 6- month period. If the loan earns interest at 7% compounded semi-annually, create an amortization schedule and find: a. the present value of the loan b. the outstanding principal after 3 years c. the amount of principal already paid after 3 years (sum of the principal repayment column for the first 3 years) d. the total interest paid on this loan (sum of the interest column)

lease provide your complete solutions to the given roblems. You may use MS Excel for your solutions. 1. A loan is to be amortized for 4 years through equal payments of PhP48,532.49 at the end of every 6month period. If the loan earns interest at 7% compounded semi-annually, create an amortization schedule and find: a. the present value of the loan b. the outstanding principal after 3 years c. the amount of principal already paid after 3 years (sum of the principal repayment column for the first 3 years) d. the total interest paid on this loan (sum of the interest column)

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!

Real Estate Finance questions. Home work must be done in EXCEL and functions must be embedded. Attached is the Homework Instructions. Also attached is an excel file (Chapter 16 Construction) that you...

pls help solve it all Pre-Assessment Checklist: Task 3 - Project The purpose of this checklist The pre-assessment checklist helps students determine if they are ready for assessment. The...

Assignment 2: Quantitative Exercises and Final Project 1: Amortization Part One: Quantitative Exercises Determine the present value solutions to period, interest, and payments. Calculate the future...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Dr.Ramsey Please assist me with my discussion post. Subject: Annuities Systematic risk evaluates the probability and extent of negative consequences to the larger body. For example, the government...

Please answer me page 51 to page 56 on the attachment. is a multiple choice questions. Thank you FAC1502/101/3/2016 Tutorial letter 101/3/2016 Financial accounting concepts, principles and procedures...

PLEASE COMPLETE NO LATER THAN 11/04 @8am Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

Assignment 4: Receivables questionnaire problems 1 and 2. Inventory questionnaire problems 1 and 2 Receivable questionnaire starts on page 97 to 100 and then answer the 2 problems Inventory...

Section 9 Completing the audit problems 1, 2, and 5. Page 119 Section 10 Writing the report problems 1, 2, and 3Page 120 ABC, INC. A Comprehensive Decision Based Case, 3rd Edition, 2015 ISBN:...

-0.2t C(t) = 120(e A study shows that the concentration C(t) (in micrograms per milliliter) of antibiotic in a patient's blood serum after t hours is ebt), where b 1 is a constant that depends on the...

A loan of $87,100 is due 10 years from today. The borrower wants to make annual payments at the end of each year into a sinking that will earn compound interest at an annual rate of 10 percent....

Treasury stock a. is a class of stock permitted by specific authority of the articles of incorporation. b. c. d. has no voting rights. has preemptive rights. is entitled to dividends

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

(Appendices) Select a commonly used product, such as gasoline or milk, and track the prices of this product over a 20-year period by creating a line graph. Explain price increases and decreases based...

(Appendices) ADJUSTING ENTRY AND PREPARATION OF FINANCIAL STATEMENTS. Michaels Hardware has the following unadjusted trial balance at the end of 19x3: The following data are also available for...

(Appendices) PRESENTATION OF SALES REVENUE AND COST OF GOODS SOLD. The accountant for Sneva, Inc., collected the following data for 19x: LO3 REQUIRED: Assume that Sneva uses the periodic system and...