Answer:
d) negative cash flow appearing in red font.
Explanation:
Colour coding is a type of excel formatting for financial modelling.
Color coding allows anyone to immediately pick up your model and know what can be changed (assumptions) and what should not be altered (formulas).
Example:
negative cash flow (Cash outflow) of the company appears in red font while positive cash flow (Cash inflow) of the company appears in green font.
Answer:
$7337.65.
Explanation:
Loan is what someone in need of financial aid for the purpose of investment or other things collect or take money from banks, friends, family or relatives with the intent of returning it back(probably with interest too).
From the question, we are given the following information: the total loan amount on an office building = $1 million = 1,000,000 at a 10% interest (accrual) rate '' with payments calculated using an 8% pay rate and a 30-year loan term".
Hence, if we are to do this on Excel, we will just just use the - PMT of 8% divided by 12 = (0.00666666667) , the number of payment = 360 and the total loan amount which is going the give us the value of $7337.65.
Answer:
Variable Overhead Rate Variance - $55 favorable
Variable Overhead Efficiency Variance - $275 favorable
Over applied efficiency variance - $330 favorable
Explanation:
The computations are shown below:
Variable Overhead Rate Variance = Actual Hours × (Actual Rate - Standard variable overhead Rate)
= 1,100 hours × ($2.70 - 2.75)
= $55 favorable
Variable Overhead Efficiency Variance = Standard variable overhead Rate × (Actual Hours - Standard Hours)
= $2.75 × (1,100 hours - 1 × 1,200)
= $275 favorable
So, the over-applied variable overhead would be
= $55 favorable + $275 favorable
= $330 favorable
Answer:
a. The amounts that are included in Ralph's gross income this year if a tenant signs lease 1 on December 1 and makes timely payments under that lease
= $8,640
b. The amounts that are included in Ralph's gross income this year if the tenant signs lease 2 on December 31 and makes timely payments under that lease:
= $7,920
c. The amounts that are included in Ralph's gross income this year if the tenant signs lease 3 on November 30 and makes timely payments under that lease:
= $10,080
Explanation:
a) Data and Calculations:
Leases: Lease Payments Security Remarks
Deposit
Lease 1 Monthly rent = $720 $720 Refundable at the lease end
Lease 2 Yearly rent = $7,920 None None
Lease 3 Monthly rent = $720 $1,440 Non-refundable; last months' rent
1) The amounts that are included in Ralph's gross income this year if a tenant signs lease 1 on December 1 and makes timely payments under that lease
= $720 * 12 = $8,640
2) The amounts that are included in Ralph's gross income this year if the tenant signs lease 2 on December 31 and makes timely payments under that lease:
= $7,920
3) The amounts that are included in Ralph's gross income this year if the tenant signs lease 3 on November 30 and makes timely payments under that lease:
= ($720 * 12) + $1,440
= $8,640 + $1,440
= $10,080
b) Since Ralph is a cash-method taxpayer, the amounts of lease rents that are included in his gross income equal the total amounts received in the calendar-year.