You receive a loan for $402,265 from a bank at 8% interest rate. You require to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You receive a loan for $402,265 from a bank at 8% interest rate. You require to pay $70,000 at the end of each of the next eight years. Set up a spreadsheet in Excel with the following columns: Beg Balance, Payment, Interest, Loan Reduced (principle paid), Ending Balance • Compute or enter the following values for the first and second year. • Enter your values to the nearest dollar value. • Enter the Beginning and Ending Balances as positive values and the rest as NEGATIVE. Year 1: Beg Bal. $ ; Payment $ ; Interest $ Year 2: Beg Bal. $ Loan Red $ Loan Red $ Payment $ ; End Bal. $ : End Bal. $ Interest $ You receive a loan for $402,265 from a bank at 8% interest rate. You require to pay $70,000 at the end of each of the next eight years. Set up a spreadsheet in Excel with the following columns: Beg Balance, Payment, Interest, Loan Reduced (principle paid), Ending Balance • Compute or enter the following values for the first and second year. • Enter your values to the nearest dollar value. • Enter the Beginning and Ending Balances as positive values and the rest as NEGATIVE. Year 1: Beg Bal. $ ; Payment $ ; Interest $ Year 2: Beg Bal. $ Loan Red $ Loan Red $ Payment $ ; End Bal. $ : End Bal. $ Interest $
Expert Answer:
Answer rating: 100% (QA)
Year 1 Beg Bal 402265 Payment 70000 Interest 32182 8 of Beg Bal ... View the full answer
Related Book For
Principles of Corporate Finance
ISBN: 978-0077404895
10th Edition
Authors: Richard A. Brealey, Stewart C. Myers, Franklin Allen
Posted Date:
Students also viewed these accounting questions
-
Using the following information, set up a spreadsheet in Excel (based on the one on the next page). Then, determine which of the systems you will choose based on the best savings in the first year....
-
Your employer contributes $75 at the end of each week to your retirement account. The account will earn a weekly interest rate of .13 percent. How much will the account be worth when you retire in 30...
-
If you deposit $4,900 at the end of each of the next 20 years into an account paying 10.3 percent interest, how much money will you have in the account in 20 years? How much will you have if you make...
-
Joshua Tree Inc. reported that at the end of 2012 net accounts receivable of 2,050 (the net value at the end of 2011 was 1,090). Their allowance for doubtful accounts at the end of 2012 was 150 (the...
-
Derive cash disbursements for dividends Johnson & Johnson, a pharmaceutical and medical products company, reported a balance in retained earnings of $26,571 million at the beginning of the year and...
-
The following information is available for Wonderway, Inc., for 2015: Factory rent...................................................$40,000 Company...
-
Matt Lehti owns the Zap Record Shop. He is in the process of examining the following performance report: Matt is very pleased that the company had favorable variances for sales and income. However,...
-
The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about...
-
Stock A has an expected return of 6% and standard deviation of 12%. Stock B has an expected return of 10% and standard deviation of 15%. The correlation between the two stocks' returns is 0 . 75. I...
-
There is a parcel of land next to the Playful Paws, Inc. building. Ellen, the owner of this property, approached John to discuss the idea of selling it to him. John is interested. Ellen knows that...
-
How do databases benefit businesses when using queries, forms, and reports?
-
Robotic bees are tiny drones that can be used for a number of purposes other than pollinating flowers. They can be used for environmental monitoring, biological studies, and search and rescue...
-
Ingrid Boes, an Alberta employee, is being released from employment in April of the current year after 11 years of service. Ingrid's regular semi-monthly salary is $2,790.00. Calculate the gross...
-
2. Find c such that A is invertible 1 0 A= -1 -1 3 1 0 2c -4]
-
Even though the present Basel II Settlement has many advantages like: more transparent and detailed bankinformation, the rating systems, the internal models of evaluation for risks, the three pillars...
-
what are the major take aways on both Washington concesus and Beijing concesus?
-
It is possible to enhance the effects of regular physical activity by altering the type, duration, frequency, intensity, or progression of exercise. Match the situations to determine whether they are...
-
Determine the annual percentage yield for a loan that charges a monthly interest rate of 1.5% and compounds the interest monthly.
-
Why does asymmetric information push companies to raise external funds by borrowing rather than by issuing common stock?
-
True or false a. Lease payments are usually made at the start of each period. Thus the first payment is usually made as soon as the lease contract is signed. b. Some financial leases can provide...
-
Consider three securities: a. A floating-rate bond. b. A preferred share paying a fixed dividend. c. A floating-rate preferred. If you were responsible for short-term investment of your firms excess...
-
Sketch (by hand) the graphs of each of the following functions over four periods. Then sketch the extensions of each of the functions as both an even and odd periodic function. Determine the...
-
Consider the function \(f(x)=x,-\pi
-
Differentiate the Fourier sine series term by term in Problem 18. Show that the result is not true. Why not? Data from Problem 18 Consider the function \(f(x)=x, 0
Study smarter with the SolutionInn App