Question
I need to know how to get the blank tax sheet to look like the filled tax sheet with formulas. This is the instuctions given
I need to know how to get the blank tax sheet to look like the filled tax sheet with formulas. This is the instuctions given by my professor.
-Cumulative interest payments for each year. Write a formula that automatically calculates this value for the corresponding periods so that it can be copied down for each year. Assume that the loans all begin in January so that no partial years need to be calculated. Note that to accommodate variable periods (the payments/yearare variableandcouldrepresentmonths,quarters,etc.)the beginningandendingperiods mustbecalculationsthatreferencethenumberof periodsperyearontheCalculator worksheet.
-Expected tax deduction for three different tax rates. In three adjacent columns, calculate the value of the expected tax deduction for tax rates of 15%, 28%, and 32% for the corresponding year (cumulativeinterestpayments*taxrate). Your formula for tax deduction should drag both down the column and across the row.
Total amount of interest paid. Sum the cumulative interest.
Pictures included are the empty tax sheet, the data I was given, and how the tax sheet should look, i am clueless how to get to the end result with formulas.
State Savings and Loan Tax Evaluation Cumulative Intrest TAX TAX TAX For Year 4 Year 10 12 10 15 16 13 14 16 17 18 19 20 21 21 23 26 23 24 25 26 27 28 29 28 31 35 Total Intrest 36 Total Tax Bene 37 State Savings and Loan Tax Evaluation Cumulative Intrest TAX TAX TAX For Year 4 Year 10 12 10 15 16 13 14 16 17 18 19 20 21 21 23 26 23 24 25 26 27 28 29 28 31 35 Total Intrest 36 Total Tax Bene 37Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started