Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, i am trying to figure out how to find the loan amount for this particular sheet. What formula would I need to use, and

image text in transcribed

Hello, i am trying to figure out how to find the loan amount for this particular sheet. What formula would I need to use, and what would I input inside the formula?

Thank you

Aurib 09. Final Exam Practice Fall 2001 - Excel Search [Alt Jett, Paul Brendon IP File Home Insert Page Layout Formulas Data Review View Developer Help Data Streamer Power Pro Share Comments Analytic Schrer - IL Smart saeenshot be 5 1 i Pivot Table Recommended Thole Pivot tables Tables NO Picture Shapes and 3D Models Ilustration 4 .. M VR Visi Date olenph Pocke Grup Visualizer ? Recommended Charts Equation Symbol Maps Pie Chart Lin My Addins Slicer Timine Camel 3D Map A 4 Worth Signature line Text Her Box Foote, Obec Tual Line Column Wind Loss Sparkles Charls T FILES LT Lenment Symbol EZ ta G 11 K L MN 0 A S T T U V w X | IS S A 1 Au 2 Facility Corts 3 Down Payment # of Pets per Year 5 Years 6 APR 7 Ist Payment Date 250,000 40,000 12 D Summy Cakulitium Loan Amount No. Periode Monthly Rate Monthly Payment Total interest Paid 95 0.44 5.25% 4,19/2011 Payment Payment Date Beginning Balance Intro Principal Payment Endir Balance 10 15 1 2 3 5 7 10 12 11 14 15 18 17 1a 19 2 21 22 23 24 25 20 27 22 29 30 39 32 33 34 35 35 37 13 12 19 14 15 16 17 18 19 20 21 22 74 27 28 29 49 43 Car Choices Employees Customers Macro Sue's Bakery Budget Shipping costs Apartments Baseball Team Stats Student Scholarship Student Scholarship (2) Loan Amortization 2017 Projected Sale: + Ready B Aurib 09. Final Exam Practice Fall 2001 - Excel Search [Alt Jett, Paul Brendon IP File Home Insert Page Layout Formulas Data Review View Developer Help Data Streamer Power Pro Share Comments Analytic Schrer - IL Smart saeenshot be 5 1 i Pivot Table Recommended Thole Pivot tables Tables NO Picture Shapes and 3D Models Ilustration 4 .. M VR Visi Date olenph Pocke Grup Visualizer ? Recommended Charts Equation Symbol Maps Pie Chart Lin My Addins Slicer Timine Camel 3D Map A 4 Worth Signature line Text Her Box Foote, Obec Tual Line Column Wind Loss Sparkles Charls T FILES LT Lenment Symbol EZ ta G 11 K L MN 0 A S T T U V w X | IS S A 1 Au 2 Facility Corts 3 Down Payment # of Pets per Year 5 Years 6 APR 7 Ist Payment Date 250,000 40,000 12 D Summy Cakulitium Loan Amount No. Periode Monthly Rate Monthly Payment Total interest Paid 95 0.44 5.25% 4,19/2011 Payment Payment Date Beginning Balance Intro Principal Payment Endir Balance 10 15 1 2 3 5 7 10 12 11 14 15 18 17 1a 19 2 21 22 23 24 25 20 27 22 29 30 39 32 33 34 35 35 37 13 12 19 14 15 16 17 18 19 20 21 22 74 27 28 29 49 43 Car Choices Employees Customers Macro Sue's Bakery Budget Shipping costs Apartments Baseball Team Stats Student Scholarship Student Scholarship (2) Loan Amortization 2017 Projected Sale: + Ready B

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Issues In Behavioral Finance

Authors: Simon Grima

1st Edition

1787698823, 978-1787698826

More Books

Students also viewed these Finance questions