In this guided Practice Lab, we will use personal and corporate tax information to create a basic income tax model and understand how forms of business structure give rise to different taxes. We will enhance your productivity by practicing several different keyboard shortcuts and format models using best practices, working with Excel tables, and gaining comfort around analysis calculations.
By the end of this lab, you will understand how to set up tables in Excel and perform modeling with data using tools such as MATCH, INDEX, XLOOKUP, and Goal Seek.
CFI’s Commercial Banking & Credit Analyst (CBCA)™ Program offers skills including credit structuring, documentation, and review procedures. From beginners to advanced users, the CBCA® program is designed to help you become a world-class commercial banker or credit analyst.
This Modeling Taxes for Different Business Structures Practice Lab is perfect for any aspiring or early-stage credit professionals, including business and commercial bankers, credit analysts, real estate lenders, equipment finance, loan & mortgage brokers, and other private (non-bank) lenders.
10 courses from beginner to intermediate level.01 Optional
16 courses from beginner to intermediate level.02 Required
23 courses in advanced and intermediate levels.03 Required
Submit your CBCA™ checklist and order your certificate.04 Required
Get access to the Global Corporate Finance Society.05 Optional
Commercial Banking & Credit Analyst (CBCA)™ courses are offered 100% online, allowing you the flexibility to start the Commercial Banking & Credit Analyst (CBCA)™ program anytime and learn when it’s most convenient for you.
The program is a part of the All Access Subscription, which includes all programs and courses.
CFI courses are designed by instructors with over 21 years of financial analyst training experience.