Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone help me with these formulas?! 2. In Dii, calculate the Fall Term Total by adding the One-Time amount (B11) to the Monthly amount

Can someone help me with these formulas?! image text in transcribed image text in transcribed

2. In Dii, calculate the Fall Term Total by adding the One-Time amount (B11) to the Monthly amount (C11) multiplied by the Months in the Term (B5). Make sure to use an absolute reference in the formula so that it will copy correctly in the next step. Note: the formulas you write will result in O because you have not yet added data. 3. Copy the formula in D11 down the column through D18. 4. Create similar formulas in G11, J11, and M11 and copy the formulas down the columns through row 18. 5. In N11, sum the totals in columns D, G, J, and M. Copy this formula down column N through row 18. 6. In cells B19:N19, sum rows 11 through 18. 7. Copy B18:N18 to B22:N53. 8. In cells B54:N54, sum rows 22 through 53. 9. In cells B56:N56, calculate NET income which equals Total Income minus Total Expenses. 10. In D57, calculate Projected End Balance by adding Net in column D to the Starting Balance (B4). 11. In G57, calculate Projected End Balance by adding Net in column G to the Project End Balance in column D. Copy G57 to 157 and M57. 12. Save your work. H I J K L M N College Student Budget 4 5 Starting Balance: # of Months in the Term: $500.00 3 Winter Term One Time Monthly Total Spring Term One Time Monthly Total Total Summer Term One Time Monthly Total Year Total Fall Term One Time Monthly 10 FUNDING / INCOME 11 Employment 525 12 From Parents 500 13 From Student Loans 1500 14 From Scholarships 250 15 From Grants 16 From Financial Aid 17 Transfer From Savings 1000 18 Other Total FUNDING / INCOME 3250 525 1575 1575 1575 1575 1575 0 0 O 0 1575 0 0 9450 0 0 0 0 0 0 0 0 0 20 50 $300.00 $50.00 45 21 EXPENSES 22 Tuition $1.200.00 23 Fees (class, parking, lab, clubs, etc) 125 24 Housing/Rent 25 Credit Card Payments 28 Food Plan 27 Loan Payments 28 Computer and Other Equipment 29 Dorm/House Furnishings 30 Books (use 560 per class if you don't know) $240.00 31 School Supplies 25 32 Food (groceries, eating out) 33 House Supplies (cleaning, kitchen,etc) 50 34 Utilities (electric, water, trash) 35 Cell Phone Bill 33 Internet Bill 37 Travel Home or Other 38 Transportation (Around campus & town) 39 Car Payment 40 Car Insurance 41 Car Repairs 42 Fuel 43 Entertainment 44 Unhealthy Habits 45 Health Insurance (if not under parent's) 48 Medicine 47 Charitable Donations 48 Gifts Given 49 Clothing 50 Laundry 51 Child Care 52 Transfer to Savings 53 Other Total EXPENSES $0 100 $75.00 $65.00 $15.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

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

Building Database Driven Catalogs

Authors: Sherif Danish

1st Edition

0070153078, 978-0070153073

More Books

Students also viewed these Databases questions

Question

5. Identify three characteristics of the dialectical approach.

Answered: 1 week ago

Question

6. Explain the strengths of a dialectical approach.

Answered: 1 week ago

Question

4. Explain the strengths and weaknesses of each approach.

Answered: 1 week ago