subject
Business, 24.04.2021 02:00 885122bah

Mann Co. is preparing an Excel spreadsheet for its 5-year, 6%, $400,000 installment notes. The notes were issued on January 1 for $421,236. Installment payments are payable each December 31. A portion of the spreadsheet appears as follows: A B C D E 1 Effective rate: 0.06 2 Cash payments: 100,000 3 Term to maturity in years: 5 4 5 Period Cash Payment Interest Expense Change in Balance Outstanding Balance 6 0 7 1 8 2 What formula should Mann use in cell E8 to calculate the outstanding balance (book value) of the notes after the second interest

ansver
Answers: 3

Another question on Business

question
Business, 22.06.2019 02:00
Jamie lee is reviewing her finances one month later. she has provided the actual amounts paid below. use the cash budget table below to her identify the variances in her budget. each answer must have a value for the assignment to be complete. enter "0" for any unused categories. actual amounts income: monthly expenses: gross monthly salary $2,315 rent obligation $260 net monthly salary $1,740 utilities/electricity $130 savings allocation: utilities/water $10 regular savings $130 utilities/cable tv $155 rainy-day savings $20 food $160 entertainment: gas/maintenance $205 cake decorating class $90 credit card payment $25 movies with friends $50 car insurance $75 clothing $145 budgeted amounts assets: monthly expenses: checking account $1,850 rent obligation $225 emergency fund savings account $4,300 utilities/electricity $75 car $5,200 utilities/water $35 computer & ipad $1,100 utilities/cable tv $120 liabilities: food $115 student loan $6,600 gas/maintenance $95 credit card balance $1,000 credit card payment $45 income: car insurance $45 gross monthly salary $2,155 clothing $45 net monthly salary $1,580 entertainment: savings allocation: cake decorating class $90 regular savings $130 movies with friends $50 rainy day savings $20
Answers: 2
question
Business, 22.06.2019 12:30
howard, fine, & howard is an advertising agency. the firm uses an activity-based costing system to allocate overhead costs to its services. information about the firm's activity cost pool rates follows: stooge company was a client of howard, fine, & howard. recently, 7 administrative assistant hours, 3 new ad campaigns, and 8 meeting hours were incurred for the stooge company account. using the activity-based costing system, how much overhead cost would be allocated to the stooge company account?
Answers: 1
question
Business, 22.06.2019 13:50
Selected t-account balances for bloomfield company are shown below as of january 31, which reflect its accounting adjustments. the firm uses a calendar-year accounting period, but prepares monthly accounting adjustments.suppliesjan. 31 bal. 1,800 1,800 jan. 31 bal.supplies expensejan. 31 bal. 1,920 1,148 jan. 31 bal.prepaid insurancejan. 31 bal. 1,148 1,148 jan. 31 bal.insurance expensejan. 31 bal. 164 164 jan. 31 bal.wages payablejan. 31 bal. 1,400 1,400 jan. 31 bal.wages expensejan. 31 bal. 6,400 6,400 jan. 31 bal.truckjan. 31 bal. 17,376 17,376 jan. 31 bal.accumulated depreciation -truckjan. 31 bal. 5,068 5,068 jan. 31 bal.a. if the amount in supplies expense represents the january 31 adjustment for the supplies used in january, and $1,240 worth of supplies were purchased during january, what was the january 1 beginning balance of supplies? $answerb. the amount in the insurance expense account represents the adjustment made at january 31 for january insurance expense. if the original insurance premium was for one year, what was the amount of the premium, and on what date did the insurance policy start? amount of the premium $answerthe policy began on answerjune 1july 1august 1september 1october 1november 1 of the previous year.c. if we assume that no beginning balance existed in either in either wage payable or wage expense on january 1, how much cash was paid as wages during january? $answerd. if the truck has a useful life of four years (or 48 months), what is the monthly amount of depreciation expense, and how many months has bloomfield owned the truck? answermonths
Answers: 1
question
Business, 22.06.2019 14:30
You hear your supervisor tell another supervisor that a fire drill will take place later today when the fire alarm sounds that afternoon you should
Answers: 1
You know the right answer?
Mann Co. is preparing an Excel spreadsheet for its 5-year, 6%, $400,000 installment notes. The notes...
Questions
question
Mathematics, 19.01.2021 14:00
question
Mathematics, 19.01.2021 14:00
question
Mathematics, 19.01.2021 14:00
question
Mathematics, 19.01.2021 14:00
Questions on the website: 13722363