Lending model excel. Download this financial model here: https://www.

Lending model excel A comprehensive editable, MS Excel spreadsheet for tracking Fintech Mobile App finances, including yearly Online and Offline Marketing % Opportunities and development channels, summary tabs, integrates Income Statements, Balance Sheets, & Cash Flow Statements, providing a comprehensive view of financial performance. Sep 25, 2024 · Bonus Tutorial: Building a Simple Amortization Table in Under 90 Seconds. Run analysis using either Jan 14, 2018 · Help Modeling a Construction Loan w/ Two Components (Originally Posted: 04/30/2017) Would someone be willing to show me how they would model a construction loan with a senior and junior components, with junior funding first? It seems to be much more complex than the basic construction loans I have looked at. htmlToday was spent figuring out the integratio Mastering Excel Shortcuts for PC and Mac List of Excel Shortcuts Excel shortcuts - It may seem slower at first if you're used to the mouse, but it's worth the investment to take the time and Financial Modeling Guidelines CFI’s free Financial Modeling Guidelines is a thorough and complete resource covering model design, model building Dec 5, 2016 · The principle of validating a model for fair lending is similar to validating AML systems. This Lender Business Model describes a Lending Company which uses invested cash and monthly cash flows to fund loans for up to 4 types of borrowers. The foundation of any loan model is the dataset of historical loans. Machine Learning is about making predictions using data. com/2021/05/lending-bank-financial-model-10-year. Mar 28, 2023 · In order to compile and present that data for analysis, a model is needed. Download the Scenario Analysis Toolusing the Equity Waterfall Model To make this tool accessible to everyone, it is offered on a “Pay What You’re Able” basis with no minimum (enter $0 if you’d like) or maximum (your support helps keep the content =PPMT(Loan Interest Rate, Year #, Loan Amortization Period, Loan Amount) Using these functions ensures that the total amount of Debt Service will be the same each year. Crafting a comprehensive plan walks you through critical thinking on all facets of your envisioned lending business, including: Products/services to offer; Operational processes and resource needs eFinancialModels provides a wide range of industry-specific financial model templates and financial modeling services from multiple authors. Use Libor swap rate as your reference rate, which depends on YTM of the unitranche loan. Mar 27, 2020 · Each business model produces a forecasted Income Statement, Balance Sheet, and Statement of Cash Flows. The comparable multiples valuation modeling approach in Excel is very different from that of a DCF model. The model is designed to be adaptable, with built-in validation checks to ensure accuracy, and an Index tab for easy navigation and quick overview of the model’s integrity. Use Notary Financial Projection Excel before May 4, 2020 · Download the Source Files for this Watch Me Build Exercise. If you are looking to invest into serious mining operations as an operator, this financial planning spreadsheet will be of great use. This well-tested, robust, and powerful template is your solid foundation to plan a success. Learn More Feb 9, 2024 · Fintech Financial Model Excel Template. com The Lending Business Financial Model Template in Excel is for existing/startup businesses borrowing money, providing loans, and investing any surplus funds in financial investments Aug 23, 2021 · Lending Platform Financial Model (LaaS) Includes all the assumptions you need to project the gross revenues and profits of a LaaS platform (Lending as a Service). Using Excel spreadsheets is great for this kind of analysis. Loan Calculations. This version of the All-in-One is only compatible with Excel 2013, Excel 2016, and Excel 365 (see version compatibility). Jul 19, 2022 · You need to build a DCF to value the unitranche loan. Buy Now Creates 5-year Bank investment business model, Proforma Income Statement, financial statements, and financial ratios in GAAP or IFRS formats on the fly. The financial model templates will help you assess the viability of the project if you are interested in this kind of venture. Mastering Excel Shortcuts for PC and Mac List of Excel Shortcuts Excel shortcuts - It may seem slower at first if you're used to the mouse, but it's worth the investment to take the time and Financial Modeling Guidelines CFI’s free Financial Modeling Guidelines is a thorough and complete resource covering model design, model building Jan 29, 2022 · List of Free Excel Financial Model Templates. The primary stakeholders in a real estate investment are the debt and equity holders. This is called loan Dec 7, 2023 · To build a rental property model in Excel, start by gathering all relevant financial data, such as rental income, expenses, and loan details. Financial statement spreading in Excel is a crucial tool for analysts and investors who wish to dive deep into a company’s financial statements. This model is specific for a lending marketplace operator (Peer2Peer). Information can be entered in this section, including Default Rate and Default Recovery, Prepayment Rate, Advance on Senior Loan, and Senior Loan Rate. You will be able to enter the number of remaining months, which will drive the remaining expected payments along with the total loan term, interest rate, and initial loan amount. Our Excel Financial Model serves as a versatile tool for businesses seeking to gain control over their finances and plan for the future. This DCF model template provides you with a foundation to build your own discounted cash flow model with different assumptions. There are also calculations for IRR before and after Senior loan debt is paid. See download link below. Free Excel Courses Create Basic Excel Pivot Tables This product (Lending Company Financial Model - 5 Year Forecast) is an Excel template (XLSX), which you can download immediately upon purchase. You can change formulas to tweak your needs – our templates are free to May 7, 2023 · Learn to make a financial model to forecast your P&L and make it dynamic. >ä ó ÿ?. This comprehensive Excel financial model template is designed to forecast the future performance of a Lending company (mortgage, factoring, specialty lending, banking, etc). Contents: • Standard Loan including Interest Only Period option Amortization Schedule of a fixed-rate loan including an optional interest-only (IO) period. Nov 22, 2024 · While the P2P lending business model shows promising growth, it is essential for platforms to continuously evolve their strategies in response to peer-to-peer lending competition and changing regulatory environments. 5 year rolling financial projection Excel model for a leasing company borrowing funds, purchasing assets (vehicles, equipment, real estate, or even technology) for lease and providing operating and finance leases. Mar 9, 2024 · This financial model for a lending company provides a detailed, user-friendly framework for forecasting loan performance, managing financing, and projecting financial outcomes over a 5-year period with monthly projections. The most widely adopted definition followed in credit risk modeling is to define default event as the earlier date of 1) a loan becomes severely delinquent for the first time; or 2) a loss is recognized on the loan Use a financial model in Excel to model financial covenants Who should take this course? This Loan Covenants course is perfect for any aspiring credit analyst working in insurance, underwriting, rating agencies, commercial lending, corporate credit analysis, and other areas of credit evaluation. It is important to understand the loan terms, interest calculations and how to use formulas to model redemptions. Download the free Loan portfolio templates right now! Microsoft excel templates and Google Sheets link are both available. In this course, you’ll learn to use basic Machine Learning skills to predict which customers are likely to default on their loans. Nov 22, 2024 · In the lending marketplace, average loan amounts can vary significantly based on the niche. Underwrite subject property value using the direct cap method. purchase price, closing costs, etc) for the investment. It includes sections for loan assumptions, financing strategies, staffing, and detailed financial statements, supported by a visual dashboard and graphs. Let’s look at the debt investors first. Aug 23, 2021 · Lending Platform Financial Model (LaaS) Includes all the assumptions you need to project the gross revenues and profits of a LaaS platform (Lending as a Service). What is the Co-lending Model? The ready-made financial model in Excel template addresses key pain points for users by providing a comprehensive solution that streamlines the mortgage lending process through automated mortgage solutions and fintech mortgage solutions, eliminating the complexities of manual calculations. Read on to learn more about a few possible challenges of credit risk modeling in Excel Model with 4 Tier Subscription – $85. Download this financial model here: https://www. Interest-only term (months) 3. In addition, Abrigo offers a webinar on loan-pricing factors to consider and how Project Finance Modeling + Excel & VBA + Core Financial Modeling: Learn the fundamentals of Excel, accounting, 3-statement modeling, valuation, and M&A and LBO modeling from the ground up, along with project finance and infrastructure modeling case studies. Loan Default Prediction with Machine Learning Course Overview. To find out in Excel, you simply need the basic loan information and a handy function. To keep track of your credit score, you can simply utilize different tools like a financial model or an excel spreadsheet to help you have a systematic framework for tracking and fast updating. Excel is widely used and familiar to many, which makes these templates user-friendly. In the top left of the model in the gray area, there is the assumptions section that drives the model. As with the prior assumptions, these rates are a function of both originator and market data and the Loan to Deposit Ratio; Common Equity Tier 1 (CET1) Ratio; Leverage Ratio; Here is a quick preview of CFI’s Bank Balance Sheet Ratio Calculator: Loan to Deposit Ratio (LDR) The loan to deposit ratio is used to determine a bank’s liquidity by comparing the total amount of loan outstanding to deposits stored in a bank. Aug 26, 2021 · The Consumer Loan model breaks down the financing structure of a bundle of consumer loans absorbed by a lender. Apr 13, 2022 · With a few simple functions and your data, you can easily get basic loan calculations in Microsoft Excel. Enhance your pitch decks and impress potential investors with a proven, strategy template. Calculate a Loan Payment in Excel For many people, affording a new car involves knowing what the monthly payment will be. Download the Ai1 Model. Financial Model Excel Template Free Download Dec 30, 2022 · Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling. IFRS 2 Excel examples Share-based payment with service vesting condition and market condition Free downloads for many of the financial modeling templates referenced throughout our course curriculum. Below is a preview of the DCF model template: Download the Free DCF Model Template. Five year notary excel pro forma template for fundraising and business planning for startups and entrepreneurs. Notes. Below you will find the list of all IFRS calculation examples available on IFRScommunity. Bond, Loan or Note Make Whole Calculator This Excel-based real estate financial modeling course is designed for development professionals, lending/banking analysts, surveyors, and anyone interested in mastering the art of building real estate development models from scratch. Your credit score will show your solid credit history such as information about your payment behavior, duration of your credit, credit-to-debt ratio, etc. Key Components Download Startup Financial Model Template (Microsoft Excel, Google Sheets & OpenOffice Calc) We have created a ready-to-use 3-year Financial Projection Model For Startups to help you easily prepare Income Projections, Sales Projections, Cash Flow Statements, Balance Sheets, and Break-even Analysis for your startup. For instance, personal loan platforms often report averages between $8,000 and $12,000, while business loans may average $25,000 or more depending on the funding objective. highline. This product (Mining Financial Model: Ore, Gems, Minerals) is an Excel template (XLSX), which you can download immediately upon purchase. With this Excel calculator template, you can view a summary and amortization schedule with the final payment for your loan. Organize this information in a spreadsheet and use formulas to calculate metrics like cash flow, return on investment, and net operating income. Starting with MS Office 365 (for PC), MS Office 2019 (for MAC), Microsoft realized the possibility of full-fledged teamwork in Excel. Arrive at your pv of proceeds from the loan based on the periods, yield, payment frequency, and gross proceeds (cash-amort. 🔥 Take our Finance & Valuation Course: https://www. Effective revenue management not only ensures business sustainability but also builds investor confidence, which is paramount in Jan 2, 2023 · One of the first NBFCs to co-lend with ICICI Bank in 2019 was SBFC (Small Business Finance), an NBFC that provides financing to small enterprises. htmlPlan out the startup and operations of a le Loan portfolio templates are useful and practical when you need to deal with data and tables in daily work. A breakdown of the sources (e. Five year fintech three statement financial model template for fundraising and business planning for startups and entrepreneurs. Our Excel mortgage calculator spreadsheet offers the following features: works offline; easily savable; allows extra payments to be added monthly Most downloaded financial models in Excel on eFinancialModels that are related to industries like Agriculture, Hospitality, Real Estate, Renewable Energy, etc. People can often use them effectively with little to no additional training. This is a full 10-year startup lending business financial model, including a 3-statement model. Feb 10, 2024 · Going a step further in ‘loan model Simplified: Understanding the Basics’, we come to the constituents of a loan model. The PPMT function helps you determine the principal payment for a given period based on periodic, constant payments and a fixed interest rate. Solar Farm Excel Model Template is an excellent tool to assess the We have offered a downloadable Windows application for calculating mortgages for many years, but we have recently had a number of people request an Excel spreadsheet which shows loan amortization tables. It also includes a robust refinance analysis and sens Sep 16, 2024 · You can build a table in Excel to keep track of the interest rate, the loan calculation for the loan's duration, the decomposition of the loan, the amortization of the loan, and the monthly payment. Feb 21, 2024 · A money lending business plan serves as an invaluable strategic guide for establishing and operating a successful lending operation. This model helps you size a mortgage loan, based on DSCR, LTV, and debt yield. They are making a loan based on the value of property. Estimate the Yield Maintenance or % of Loan Balance prepayment penalty for a loan. 3-statement model and cap table included. Generally, benchmarks for peer-to-peer loans hover around $5,000 to $15,000. To create a loan model in Excel, you need to have a clear understanding of the loan structure, repayment terms, interest rates, and other relevant factors. This template includes 5 different examples of Amortization Schedules as well as a Line of Credit Calculator. The model then calculates various loan metrics based on assumptions entered on the Pro Forma and Loan Sizing tabs. Feb 10, 2023 · Modelling debt redemptions in Excel can be a complex undertaking. xlsFinished File https://people. careerprinciples. If many EBL’s are issued, the debt capacity of the parent will be used up and it has a real cost. +Bonus: Get 27 financial modeling templates in swipe file May 30, 2023 · Description PURPOSE OF MODEL Highly versatile and user-friendly Excel model for the preparation a of 5-year rolling 3 statement (Income Statement, Balance Sheet and Cash flow Statement) financial projection with a monthly timeline for a startup or existing business borrowing money from depositors and other sources, providing loans to various customer types and investing any surplus funds in Money lending templates are useful and practical when you need to deal with data and tables in daily work. In this tutorial you’ll get down to the basics. Assess balloon risk using the included refinance risk analysis tool. Nov 30, 2019 · In this video I build a construction loan draw in Excel with circular references. Gather Data: Obtain detailed loan data, including borrower information, loan amounts, interest rates, term, purpose of the loan, collateral type, and payment history. ). Get Notary Budget Template. Excel model for underwriting commercial mortgage loans. 00 Version 1; Add to wish list. The P2P lending websites connect the borrowers directly to the lenders. “ÑF¬ »Hþ… 0ÇôÏ9ÿr mï}„—¥ÈÛŽ@–\i;&MsGã7 ¿?÷û^_$[g€„jÇ“­09É ÄÒL—>í®x xé$9IîÃ¥ Ì%0 lU K Uë@UÈVÖ»N 44LBO Model - Excel model for leveraged buy-outs; 45Comparable Companies - Excel valuation model comparing companies; 46Combination Model - Excel valuation model for combining companies; 47Balanced Scorecard - Set of templates for building a balanced scorecard. g. While credit risk modeling in Excel can be a powerful tool for expressing and managing financial risk, it can also come with several challenges. Other significant components include the borrower’s creditworthiness and the terms of the loan. com/courses/fin As the loan matures, larger portions go towards paying down the principal. Dec 18, 2023 · Lending as a Service (LaaS): Running and Exit Financial Excel Model - 10 Year. It includes the following features: See full list on challengejp. Overview: To create a loan model in Excel, you need to have a clear understanding of the loan structure, repayment terms, interest rates, and other relevant factors. About Our Credit Analysis Template in Excel. This comprehensive Excel financial model template is designed to forecast the future performance of a Lending company (mortgage, factoring, specialty lending, banking, etc). Enter your name and email in the form below and download the free template now! Nov 29, 2008 · Here's a worksheet to help investors analyze if a rehab deal is worthwhile, and can be used to "sell" a deal to your hard money lender. Enter the loan details including starting amount and date, interest rate, amortization period, and number of payments per term. If you wish to have a further in depth explanation of real estate, the following links might prove helpful to you: Fintech Mobile App Financial Model. May 4, 2006 · The third loan type is principal and interest so think more like a mortgage for homes on this type. Dec 16, 2023 · Leasing Company 5-Year Financial Projection Model. The start month and starting loan originations are defined per each type. Check out our large inventory of state of the art financial modeling spreadsheet templates in Excel and Google Sheets Apr 7, 2022 · There are several good relationship profitability models available, including ours, called Loan Command , where you can be live in two days for as little as $80 per month with no upfront costs. Here's a step-by-step approach to analyzing a loan portfolio: Check out lending business financial models here. It offers cleaning and shaping it as needed before analysis. It allows for a quick review of a company’s financial health over different periods. A credit analysis template in Excel is a tool that provides a comprehensive analysis of a company’s financial statements. Take advantage of new opportunities for organizing teamwork in Excel. Oct 14, 2019 · Recovery Rates: Along with modeling default rates, we also model recovery rates, which represent the amount expected to be recovered by the bank on a loan in the event of a default (alternatively expressed as a rate of “loss given default”). First, it shows how to calculate and forecast cash flows. It enables meticulous planning, accurate forecasting, and insightful analysis, laying the foundation for strategic decision-making and financial success. Let's examine some of the co-advantages of lending now that its definition is apparent. edu/mgirvin/YouTubeExcelIsFun/ExcelFinanceTricks1-17. Let’s dive into the PPMT function in Excel. In financial modeling you can use Power Query to connect financial data from multiple sources, such as ERP systems or CSV files, transforming it into a structured format suitable for your model. debt and equity) and uses (e. Loans added per month 2. May 18, 2021 · Download this financial model here: https://www. There are loan templates with a total of downloads! To name a few, our selection includes various loan payment calculators, credit card and debt reduction calculators, payment schedules, and loan amortization charts. Mar 7, 2023 · Credit risk modeling is a key consideration when it comes to understanding risk and decision making for creditproducts. The Loan Amortization Table is a great tool to use when looking at the financial impact of a loan. When modelling a loan redemption in Excel, the first step is to enter the loan amount in an input cell and define the repayment term. This ease of use ensures you can start managing and analyzing your financial data immediately without a steep learning curve. Apr 22, 2024 · Financial statement spreading in Excel enhances analysis by standardizing financial data for comparison. Use these to expand your knowledge and develop your Excel financial modeling skills. Feb 7, 2021 · That said, if a loan is charged-off (in some rare cases) without being delinquent, one should still consider it as a default event. Mar 14, 2021 · About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features NFL Sunday Ticket Press Copyright Utilizing the Excel Financial Model. Key financial charts, summaries, metrics, and funding forecasts built-in. ” Nov 19, 2024 · Compatibility. The template contains line items that are used to create a detailed financial analysis of the company’s balance sheet, income statement, and financial ratios. Most likely, they will give you the accreted tranche value. 48Cash Model - Template for calculating projected financials from CFO Connection May 13, 2008 · Download Excel Files:Start File https://people. Jul 24, 2023 · Maybe you have a balloon loan instead of a fixed loan for your mortgage or vehicle. Interest-only period interest rate . This model contains an input section where loan detail can be entered such as the Number of Payments, Interest Rate, and Initial Loan Amount. Financial model presenting a business scenario of a corporation engaged in granting loans from its own capital funds or from funds sourced by investors. We The loan has capitalized interest that accumulates until the loan is paid. com, each accompanied by a corresponding illustrative Excel file. Mar 7, 2024 · Loan Metrics. Investors for P2P lending are individuals who want higher returns for their savings compared to letting it sit in the banks. Try Fintech Financial Projection Template. By using Excel’s built-in functions and formulas, you can calculate the loan’s payments, interest expenses, and remaining balance over time. smarthelping. May 24, 2022 · This version of the model is only compatible with Excel 2013, Excel 2016, and Excel 365. With this method, instead of determining a company’s intrinsic value (as above), an analyst will look at the valuation multiples of other publicly traded companies and compare them to that of the business(es) they wish to value. Download the free Money lending templates right now! Microsoft excel templates and Google Sheets link are both available. htmlWell, there were a few really mind bending This comprehensive Excel financial model template is designed to forecast the future performance of a Lending company (mortgage, factoring, specialty lending, banking, etc). Calculate the maximum loan amount using debt service coverage, debt yield, and loan-to-value tests. Mastering Excel Shortcuts for PC and Mac List of Excel Shortcuts Excel shortcuts - It may seem slower at first if you're used to the mouse, but it's worth the investment to take the time and Financial Modeling Guidelines CFI’s free Financial Modeling Guidelines is a thorough and complete resource covering model design, model building Nov 22, 2024 · Launching a peer-to-peer lending business necessitates developing a robust technology solution that enables efficient handling of all operational features. For the organization of distributed access using Microsoft Cloud OneDrive. Then, it covers estimating the debt and equity required to finance a business. Recently, more NBFCs and banks have started to expand their co-lending partnerships. Also, the following are configurable for loan type 1 in each of the 10-years: 1. With its intuitive and user-friendly interface, this model enables issuers to effortlessly navigate the entire life cycle of their securitization vehicle, making it easy to adjust pricing and bond structure to If you wish to ask any questions about such Real Estate Excel financial models, feel free to start a discussion on the respective real estate financial model page to have your questions answered by authors themselves. Aug 29, 2022 · If an institution is interested in systemizing the loan-pricing process for new-loan origination as well as annual reviews, Sageworks Loan Pricing powered by Abrigo integrates with Abrigo's loan origination software to calculate a defensible and consistent price. Columns and rows have been professionally designed so that you only need to input your data. Created with the mind of the notary business. You’ll be able to calculate loan payment, starting and ending balance, and learn to bifurcate the debt service payment to determine what proportion goes to interest versus principal. Here's the link to the corresponding blog post: https://www. multifamilymodel Download this financial model here: https://www. Download now for precise cash flow insights and scalable loan configurations. edu/mgi Jul 29, 2024 · Method 3 – Computing Capital Payment for a Certain Interest Rate on a Loan. htmlI am really happy with how the logic is goi Bank Financial Model Excel Template Bank Pro Forma Template Create fully-integrated financial projection for 5 years With 3 way financial statements inside. Sources and Uses. Features include: Centralized input sheet for rates, fees, bounties, & repayments #Excel Tutorials#Excel for Beginners#Excel for filipino Entrepreneur Addressing the pain points of ready-made financial model users, the Peer-to-Peer Lending Excel proforma mitigates risks inherent in P2P lending by offering a comprehensive planning tool that enables quick and reliable financial insights. Loan metrics include payment, DSCR, debt yield, and LTV. A webpage with “100+ Excel Spreadsheets. Explore and download our free Excel Financial Modeling templates below, designed to be flexible and help you perform various kinds of financial analysis and build financial models. This platform forms the backbone of your P2P lending business model, facilitating seamless interactions between borrowers and lenders while ensuring data security and regulatory compliance. Jul 3, 2024 · Download our free Excel monthly amortization schedule template to generate your monthly loan amortization schedule along with instructions. Nov 18, 2023 · This version of the model is only compatible with Excel 2013, Excel 2016, and Excel 365 Download the Self Storage Acquisition Model To make this model accessible to everyone, it is offered on a “Pay What You’re Able” basis with no minimum (enter $0 if you’d like) or maximum (your support helps keep the content coming – typical real Loan and Debt Templates This page is a collection of various Excel Templates to manage debt and loans. Mastering Excel Shortcuts for PC and Mac List of Excel Shortcuts Excel shortcuts - It may seem slower at first if you're used to the mouse, but it's worth the investment to take the time and Financial Modeling Guidelines CFI’s free Financial Modeling Guidelines is a thorough and complete resource covering model design, model building Oct 29, 2024 · Excel’s Power Query allows you to connect, import, and transform data from various sources. A key issue about the EBL is whether the effects of the EBL should be added to the returns. This calculates Lender cash flows before and after Senior Debt is paid. It includes the following features: The Lending Business Financial Model Template in Excel is for existing/startup businesses borrowing money, providing loans, and investing any surplus funds in financial investments Mar 22, 2021 · This step-by-step tutorial will take you through an example of using Microsoft Excel to create a financial model with debt financing. That’s fine here because the terms of the Debt are simple: there’s a fixed annual interest rate, fixed amortization period, no accrued interest (also known as PIK Interest The CMBS/ABS Securitization Excel Model is a powerful tool designed to simplify the complex process of asset-backed securitization. 00 Version 1 Standard Excel Model – $80. The analysis is geared toward satisfying their risk/return profiles. The fair lending system, like the AML system, draws from data supplied from another source, such as the Sep 7, 2024 · This also works as a forecasting model by displaying the expected future principal and interest of the existing loans. Transform your lending strategy with our comprehensive 10-year Loan Business Financial Model. To make this model accessible to everyone, it is offered on a “Pay What You’re Able” basis with no minimum (enter $0 if you’d like) or maximum (your support helps keep the content coming – similar real estate DCF models sell DCF Model Template. To make these files accessible to everyone, they are offered on a “Pay What You’re Able” basis with no minimum (enter $0 if you’d like) or maximum (your support helps keep the content coming – similar real estate training exercises sell for $100 – $300+). aza kmer oagh xft zrvl pctr gwht juhqoeag ghbizsb xrdlg