Monthly Budget | Beginning Balance | 2387.12 | |||||||||
Date | Gas | Groceries | Dining out | Phone | Insurance | Cable | Rent | Electric | Miscellaneous | Deposit | Balance |
1-Jan | 36.75 | 42.5 | 113.72 | 145.63 | 750 | 1051.85 | 2350.37 | ||||
2-Jan | 2350.37 | ||||||||||
3-Jan | 2350.37 | ||||||||||
4-Jan | 102.35 | 4.3 | 100 | 2343.72 | |||||||
5-Jan | 43.78 | 2299.94 | |||||||||
6-Jan | 2299.94 | ||||||||||
7-Jan | 2299.94 | ||||||||||
8-Jan | 2299.94 | ||||||||||
9-Jan | 2299.94 | ||||||||||
10-Jan | 2299.94 | ||||||||||
11-Jan | 2299.94 | ||||||||||
12-Jan | 2299.94 | ||||||||||
13-Jan | 2299.94 | ||||||||||
14-Jan | 2299.94 | ||||||||||
15-Jan | 2299.94 | ||||||||||
16-Jan | 51.33 | 17.98 | 2135.69 | 4366.32 | |||||||
17-Jan | 136.44 | 42.31 | 4187.57 | ||||||||
18-Jan | 4187.57 | ||||||||||
19-Jan | 22.37 | 128.99 | 75.43 | 3960.78 | |||||||
20-Jan | 3960.78 | ||||||||||
21-Jan | 3960.78 | ||||||||||
22-Jan | 3960.78 | ||||||||||
23-Jan | 3960.78 | ||||||||||
24-Jan | 3960.78 | ||||||||||
25-Jan | 3960.78 | ||||||||||
26-Jan | 3960.78 | ||||||||||
27-Jan | 3960.78 | ||||||||||
28-Jan | 3960.78 | ||||||||||
29-Jan | 3960.78 | ||||||||||
30-Jan | 3960.78 | ||||||||||
31-Jan | 3960.78 | ||||||||||
Sum | 102.9 | 238.79 | 93.83 | 128.99 | 113.72 | 145.63 | 750 | 75.43 | 64.59 | 3287.54 | 98925.77 |
Average | 34.3 | 119.395 | 46.915 | 128.99 | 113.72 | 145.63 | 750 | 75.43 | 21.53 | 1095.847 | 3191.154 |
Count | 3 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 3 | 3 | 31 |
Max | 43.78 | 136.44 | 51.33 | 128.99 | 113.72 | 145.63 | 750 | 75.43 | 42.31 | 2135.69 | 4366.32 |
Min | 22.37 | 102.35 | 42.5 | 128.99 | 113.72 | 145.63 | 750 | 75.43 | 4.3 | 100 | 2299.94 |
Part g | i | B39 | |||||||||
ii | C42 | ||||||||||
iii | D38 | ||||||||||
iv | K40 | ||||||||||
v | L41 | ||||||||||
Part h | L38 |
This problem involves creating a monthly budget. The column headings for your expenses are given as...
This problem involves creating a monthly budget. The column headings for your expenses are given as well as a column for any deposits and a column for the balance in your checking account. The spreadsheet gives you several rows with values inserted. a.) In cell L4, enter 2,387.12 and format as accounting. b.) In cell L6, enter a formula which takes the starting balance in cell L4 and subtracts any expenses for this row (Hint: you may subtract the SUM...
This worksheet will compute the monthly value of an amortized loan for 36 months. This will be a worksheet in which the loan value or principal, interest rate, and monthly payment can be changed and the worksheet will automatically update. Within the worksheet there will be some absolute cell referencing that is needed and some relative cell referencing that is needed. You will need to determine which is appropriate. Title the worksheet "Amortization of Car Loan" in cell A1. Leave...
Problem 5-21 You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year mortgage with monthly payments and an initial balance of $800,000. The mortgage is currently exactly 1872 years old, and you have just made a payment. If the interest rate on the mortgage is 5.25% (APR), how much cash will you have from the sale once you pay off the mortgage? Complete the steps below using cell references to given data or previous...
Please follow directions and make explanations legible. Project Description: In this problem, you will calculate the total economic profit for each of the two altematives and choose the best employment altemative. For the purpose of grading the project you are required to perform the following tasks Points Possible Instructions 1 Start Excel. , In cell D27, by using a cell reference, enter the annual salary under the Belle Touché option. Refer to an appropriate cell among H6-H10 3In cell E27,...
Problem 8-18 Professor Wendy Smith has been offered the following deal: A law firm would like to retain her for an up- front payment of $50,000. In return, for the next year the firm would have access to eight hours of her time every month. Smith's rate is $550 per hour and her opportunity cost of capital is 15% per year. What does the IRR rule advise regarding this opportunity? What about the NPV rule? Complete the steps below using...
Please input answers as excel formula (for example d27 is = h6) and make explanations legible. Project Description: In this problem, you will calculate the total economic profit for each of the two altematives and choose the best employment altemative. For the purpose of grading the project you are required to perform the following tasks Points Possible Instructions 1 Start Excel. , In cell D27, by using a cell reference, enter the annual salary under the Belle Touché option. Refer...
airements 1 In cell D11, by using cell references, calculate the monthly interest rate of the current credit card (1 pt.). 2 In cell D12, by using cell references, calculate the interest payment on the current credit card (1 pt). Note: The output of the expression or function you typed in this cell is expected as a positive number. 3 In cell D13, by using cell references, calculate the monthly interest rate of the new credit card (1 pt.) 4...
Please show the steps BoyuQuCh7CaseStudy - Excel File Insert Page Layout Formulas Data Review View Add-ins ACROBAT QuickBooks Tell me what you want to do Sign in Share Σ Autosum Calibri Fill Paste в ㅣ u . re. O . . _ Ξ_ 트트 분 Merge & Center. $. % , 'i..g Conditional Format as Cell Insert Delete Format Sort & Find & Filter Select Formatting Table Styles Clipboard Font Alignment Number Cells Editing E3 Input Area Calculations 2 Facility...
Please show formula !!! Preparing a Cash Budget with Supporting Schedules using Excel's Multi-Tab Cell Referencing and Basic Math Functions S&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments to suppliers. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer...
Formulas - Setup the worksheet with formulas! 1. Open the MT Data file and save it as MT School Budget. Select the Budget sheet if it's not already showing on your screen. 2. In D11, 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:...